Seems simple, but I'm not figuring it out. I have a one-page sheet on which
others will periodically add information to some columns. At the bottom, I
want a row to display the last valid number in that column - whether it's on
the 5th row or the 40th row. So, if the cell is blank or has anything other
than a number (like an invalid formula) it should go up to the last valid
number. Finally, remind me how I get a cell to be blank if the result of the
formula is either 0 or invalid because some source-cells in the formula have
not yet been filled in - just so the worksheet is cleaner when printed.
Thank you.
--
DR