J
John Flynn
I have a column of numbers. The column could have anywhere from 1 to 25
entries. If I want to automatically list the very last entry into
another cell somewhere else in the spreadsheet, how would I do that?
Example
1 2 3
A $25.00
B $35.00
C $10.00
D
E
F
G
How would I automatically get excel to list the value in C1 in another
cell. Keep in mind that the cells in the entire column might have
entries, or only a few cells might have entries. I just want the last
entry of the column to be listed in a cell located elsewhere in the
spreadsheet.
Hope this isn't too confusing.
Thanks,
John
entries. If I want to automatically list the very last entry into
another cell somewhere else in the spreadsheet, how would I do that?
Example
1 2 3
A $25.00
B $35.00
C $10.00
D
E
F
G
How would I automatically get excel to list the value in C1 in another
cell. Keep in mind that the cells in the entire column might have
entries, or only a few cells might have entries. I just want the last
entry of the column to be listed in a cell located elsewhere in the
spreadsheet.
Hope this isn't too confusing.
Thanks,
John