You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"BAKERSMAN" wrote in message
...
Worked perfectly!! Thanks!

"T. Valko" wrote:

Try this:

=LOOKUP(REPT("Z",255),A:A)

Assumes there are no formula blanks (empty TEXT strings) within the
range.

--
Biff
Microsoft Excel MVP


"BAKERSMAN" wrote in message
...
How do I look up the last alpha numeric value in a column? I can get
the
last
numerical value just not the alpha numerical one. Can someone help?