Lookup the last alpha numeric value in a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Try this:

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Alpha to Numeral column name 3
separating alpha numeric vlue 23
Lookup the last alpha numeric value 7
Lookup values in a column 1
change rows and colums to display alpha instead of numerics 1
lookup value from different workbook 1
How do i change column header from R[1] C format to A1 format? 4
Separating Alpha from Numeric in Address Cell in Excel 1

Back
Top