Eric

Try this and change the column to suit

=LOOKUP(6.022*10^23,A:A)

Mike

"Eric" wrote:

In Excel 2003, I have a list in a column. I'd like a function/formula that
returns the last value in the column.

For example, if the list looks like:
10
20
5
50
22

I'd like it to return 22.

Any suggestions?

Thanks.