Lookup the last alpha numeric value
 

I need to look up the last alpha numeric value in a row.

Lookup the last alpha numeric value
 

Assuming source data is in row 2,

Put in say, A3 and array-enter the formula,
ie press CSE* instead of just pressing ENTER:
=INDEX(2:2,MAX((2:2<"")*COLUMN(2:2)))

*CSE = CTRL+SHIFT+ENTER
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"BAKERSMAN" wrote:
I need to look up the last alpha numeric value in a row.

Lookup the last alpha numeric value
 

Ok how do you lookup the last alpha numeric value in a column L ?

"Max" wrote:

Assuming source data is in row 2,

Put in say, A3 and array-enter the formula,
ie press CSE* instead of just pressing ENTER:
=INDEX(2:2,MAX((2:2<"")*COLUMN(2:2)))

*CSE = CTRL+SHIFT+ENTER
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"BAKERSMAN" wrote:
I need to look up the last alpha numeric value in a row.

Lookup the last alpha numeric value
 

Array-enter in say M1:
=INDEX(L1:L65535,MAX((L1:L65535<"")*ROW(1:65535)) )
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"BAKERSMAN" wrote:
Ok how do you lookup the last alpha numeric value in a column L ?

Lookup the last alpha numeric value
 

This is pulling the first alpha numeric value, is there a way to pull that
last value.

"Max" wrote:

Array-enter in say M1:
=INDEX(L1:L65535,MAX((L1:L65535<"")*ROW(1:65535)) )
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"BAKERSMAN" wrote:
Ok how do you lookup the last alpha numeric value in a column L ?

Lookup the last alpha numeric value
 

Try this:

=LOOKUP(2,1/(L1:L65535<""),L:L)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"BAKERSMAN" wrote in message
...
This is pulling the first alpha numeric value, is there a way to pull that
last value.

"Max" wrote:

Array-enter in say M1:
=INDEX(L1:L65535,MAX((L1:L65535<"")*ROW(1:65535)) )
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"BAKERSMAN" wrote:
Ok how do you lookup the last alpha numeric value in a column L ?

Lookup the last alpha numeric value
 

"BAKERSMAN" wrote:
This is pulling the first alpha numeric value, is there a way to pull that
last value.

I lost you there. Doesn't the earlier extract the last value in col L?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Lookup the last alpha numeric value
 

Don't forget the "array-enter" bit, it makes a world of difference
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---