for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

102 watchers

larkim Nov 2019 11:12am, 29 Nov 2019 9,630 posts	Quote Pin larkim Yes, but that only works in A3? The cell can't test itself.
SPR Nov 2019 11:15am, 29 Nov 2019 29,738 posts	Quote Pin SPR Yes indeed, lol.
GregP Nov 2019 12:49pm, 29 Nov 2019 116,439 posts	Quote Pin GregP Between the up and the down, Um, yes. uparrow CELL downarrow
um Nov 2019 3:55pm, 29 Nov 2019 1,445 posts	Quote Pin um Dio - you could use conditional formating to highlight the cells that need changing if that helps. I'd probably use another sheet rather than more columns. Put the source data in one, then the display data in other, with the whole sheet (more or less) set to if(source!a2="", a1,a2), or whatever algorithm/filler you want. But I'm a big believer in 'keep in simple'
Pothunter Nov 2019 4:02pm, 29 Nov 2019 1,741 posts	Quote Pin Pothunter Sort the sheet on that column. Blanks will all be at top (or bottom - can’t default!). Depending on volumes just copy and paste, or search and replace
Pothunter Nov 2019 4:03pm, 29 Nov 2019 1,742 posts	Quote Pin Pothunter *can’t remember default
Diogenes Nov 2019 4:20pm, 29 Nov 2019 42,895 posts	Quote Pin Diogenes I did it in the end, there was a lot of manual processes Copy and pasting =B$1 in every cell where there was a value was the most of it.
run free Dec 2019 10:30am, 2 Dec 2019 3,655 posts	Quote Pin run free @Dio - +1 for what @Um says. It also helps for auditing purposes and being able to do checks. For example, there could have been a data entry mistake. @GregP - in the Developer tab use the Spin Button form control (Developer Controls Insert Form Controls Spin Button) . You can link the control to a cell easily - Right click the control and Format Control - then in the Control tab enter a cell in the Cell Link field. Note: If you have chosen the ActiveX controls you will not get the same properties. Make sure it is the Spin Control from the Form Controls
run free Dec 2019 10:32am, 2 Dec 2019 3,656 posts	Quote Pin run free Oh just learned that inserting a pipe symbol " " gives a hard return... ...should say Developer - Controls - Insert - Form Controls - Spin Button
run free Dec 2019 10:42am, 2 Dec 2019 3,657 posts	Quote Pin run free @gregP That is the easiest way.....but if you really wanted to have an Up Arrow above a cell and a Down Arrow below a cell - then suggest you use the Up and Down block arrows in the Insert - Illustrations - Shapes. You'll need to add code to increase or decrease the numbers.