New Posts For Thread: Excel help please? S/S Miss Behavinghttps://community.betfair.com/chit_chat/go/thread/view/94038/30502259/excel-help-please-ss-miss-behavingMany hundreds of times over decades I have been able to DRAG formulae from cell to cell down a column e.g. to see the effect of compounding..e.g. =(F300-F299)*1.1 for 10% growth. copied down calculates (F301-F300)*1.1 then (F302-F301)*1.1 ad infinituValet parking for Kincsem at the restaurant of his choice imv. ( He probably likes a drive-through )https://community.betfair.com/chit_chat/go/thread/view/94038/30502259/excel-help-please-ss-miss-behaving?post_id=544795061#544795061Valet parking for Kincsem at the restaurant of his choice imv. ( He probably likes a drive-through )Wed, 20 May 2015 11:03:55 -0500Dunnit : ooh - i say! aNOTHER man who knows!!https://community.betfair.com/chit_chat/go/thread/view/94038/30502259/excel-help-please-ss-miss-behaving?post_id=544794261#544794261Dunnit : ooh - i say! aNOTHER man who knows!!Wed, 20 May 2015 10:27:09 -0500I am ATHEIST.. and you KNEW IT! GRRRR!Cheers anyway.. I'll have a play with that kincsem TY!https://community.betfair.com/chit_chat/go/thread/view/94038/30502259/excel-help-please-ss-miss-behaving?post_id=544794173#544794173I am ATHEIST.. and you KNEW IT! GRRRR!Cheers anyway.. I'll have a play with that kincsem TY!Wed, 20 May 2015 10:23:16 -0500ExampleJan 100Feb 110Mar Apr MayJunJulAugSepOctNovDecYearAssuming the 110 in cell B2 is a formula based on the 100 (e.g. B1*1.1) then double clicking cell B2 will shoot the formula down to DecIt stops there when it meet the blank cell between Dechttps://community.betfair.com/chit_chat/go/thread/view/94038/30502259/excel-help-please-ss-miss-behaving?post_id=544793871#544793871ExampleJan 100Feb 110Mar Apr MayJunJulAugSepOctNovDecYearAssuming the 110 in cell B2 is a formula based on the 100 (e.g. B1*1.1) then double clicking cell B2 will shoot the formula down to DecIt stops there when it meet the blank cell between DecWed, 20 May 2015 10:08:46 -0500You drag down formulas? Here is a tip for you drag artistes.Look at the black rectangle around the active cell.Look at the bottom right corner of the active cell. It is different. There is a small black square there.Now look at the cursor. It is ahttps://community.betfair.com/chit_chat/go/thread/view/94038/30502259/excel-help-please-ss-miss-behaving?post_id=544793729#544793729You drag down formulas? Here is a tip for you drag artistes.Look at the black rectangle around the active cell.Look at the bottom right corner of the active cell. It is different. There is a small black square there.Now look at the cursor. It is aWed, 20 May 2015 10:02:21 -0500I'd never even notissed that 'options' button before - neat innit! :)https://community.betfair.com/chit_chat/go/thread/view/94038/30502259/excel-help-please-ss-miss-behaving?post_id=544792961#544792961I'd never even notissed that 'options' button before - neat innit! :)Wed, 20 May 2015 09:20:59 -0500Cheers Barry!, very helpful that ( I presume you've created a few circular references in your time )https://community.betfair.com/chit_chat/go/thread/view/94038/30502259/excel-help-please-ss-miss-behaving?post_id=544792649#544792649Cheers Barry!, very helpful that ( I presume you've created a few circular references in your time )Wed, 20 May 2015 09:00:23 -0500HEY BARRY - You'se a GENIUS Job Done .. thank-you VERY much!!https://community.betfair.com/chit_chat/go/thread/view/94038/30502259/excel-help-please-ss-miss-behaving?post_id=544790797#544790797HEY BARRY - You'se a GENIUS Job Done .. thank-you VERY much!!Wed, 20 May 2015 06:03:36 -0500No, 'paste special' doesn't help either. Somehow my excel software seems to have been 'corrupted'!I'm considering saving the sheet as a different (older) version and see if that helps.https://community.betfair.com/chit_chat/go/thread/view/94038/30502259/excel-help-please-ss-miss-behaving?post_id=544790789#544790789No, 'paste special' doesn't help either. Somehow my excel software seems to have been 'corrupted'!I'm considering saving the sheet as a different (older) version and see if that helps.Wed, 20 May 2015 06:01:47 -0500Imagine, in example above, cell F299 had the value 100.. (the initial/original cell has a value yes)entering =F299*1.1 in cell F300 produces the result 110 (obviously).Just like creating a series of simple numbers or dates or any other you can, normahttps://community.betfair.com/chit_chat/go/thread/view/94038/30502259/excel-help-please-ss-miss-behaving?post_id=544790749#544790749Imagine, in example above, cell F299 had the value 100.. (the initial/original cell has a value yes)entering =F299*1.1 in cell F300 produces the result 110 (obviously).Just like creating a series of simple numbers or dates or any other you can, normaWed, 20 May 2015 05:58:02 -0500