List Cell Value In Another Cell

[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

 

[Peo Sjoblom]

If they are numbers

=LOOKUP(9.99999999999999E+307,A:A)

will retrun the last numeric entry

 

[John Flynn]

Peo.... thank you VERY MUCH! Your formula worked great! Have a nice
evening!

John