Lookup the last alpha numeric value in a column
 

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?

Lookup the last alpha numeric value in a column
 

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?

Lookup the last alpha numeric value in a column
 

Please refrain from posting the same question more than once


--
Regards,

Peo Sjoblom



"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?

Lookup the last alpha numeric value in a column
 

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?

Lookup the last alpha numeric value in a column
 

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?