G
Guest
Using excel 2007. I have a range consisting of "X" cells (monthly total
results) in a column that progressively changes in value as the year
progresses. There MAY be several successive entries for the same month, the
dates of which are recorded in the same row, but in a a neighbor column. I
want to automatically reference ONLY THE LAST CELL corresponding to the last
date recorded.
Is there a worksheet function that will give me the results of the LAST
VALUED CELL IN A COLUMN?
results) in a column that progressively changes in value as the year
progresses. There MAY be several successive entries for the same month, the
dates of which are recorded in the same row, but in a a neighbor column. I
want to automatically reference ONLY THE LAST CELL corresponding to the last
date recorded.
Is there a worksheet function that will give me the results of the LAST
VALUED CELL IN A COLUMN?