Lookup the last alpha numeric value in a column

[Guest]

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?

 

[T. Valko]

Try this:

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

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

 

[Peo Sjoblom]

Please refrain from posting the same question more than once

 

[Guest]

Worked perfectly!! Thanks!

Try this:

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

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

 

[T. Valko]

You're welcome. Thanks for the feedback!