G
Guest
I need to look up the last alpha numeric value in a row.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
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
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
G
Guest
Ok how do you lookup the last alpha numeric value in a column L ?
G
Guest
Array-enter in say M1:
=INDEX(L1:L65535,MAX((L1:L65535<>"")*ROW(1:65535)))
=INDEX(L1:L65535,MAX((L1:L65535<>"")*ROW(1:65535)))
G
Guest
This is pulling the first alpha numeric value, is there a way to pull that
last value.
last value.
R
Ragdyer
Try this:
=LOOKUP(2,1/(L1:L65535<>""),L:L)
=LOOKUP(2,1/(L1:L65535<>""),L:L)
G
Guest
BAKERSMAN said: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?
---
M
Max
Don't forget the "array-enter" bit, it makes a world of difference
---
---