Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help Please
A row of 12 cells representing 12 months, all of which have an initial
value of zero. Each month a value is inserted into one cell, with the value remaining as each month passes. There is another cell in a separate worksheet into which I want to place the most recently entered value from the 12 cell row, i.e. it will overwrite the previous value. I've tried using 'if' statements and various formula listed in the Help files but without success. Can anyone offer a solution please? |