Quote:
Originally Posted by horse-eater
so, to do an entire set, you have to highlight all the cells repeat said process...
but the cells that i want to set the amount for, i just set the amount and omit that cell from the "calculate" function?
|
??? Um...I'm confused now...
Ok let's say you put 0, 1, 1.7, 2, 3.............5, you would highlight all the cells starting at 3 and ending at 5...in this case there would be 13 cells highlighted, the 3 the 5 and 11 cells in between. Hit calculate and it will evenly populate the other 11 cells between 3 and 5. There's all kinds of right click tricks/tips in the manual for the FIC...it's worth a read...it'll definitely save you some time.