use match to find the row of any number larger than possible in your column
and index to give you the value in that row. Use "zzzzzzzzzz" for text.
=INDEX(A:A,MATCH(99999999999999,A:A))

--
Don Guillett
SalesAid Software

wrote in message
ups.com...
Quick question. How do I get the value of the bottom cell in a certain
column (actually always column A)?