B
BAKERSMAN
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.
M
Max
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
B
BAKERSMAN
Ok how do you lookup the last alpha numeric value in a column L ?
M
Max
Array-enter in say M1:
=INDEX(L1:L65535,MAX((L1:L65535<>"")*ROW(1:65535)))
=INDEX(L1:L65535,MAX((L1:L65535<>"")*ROW(1:65535)))
B
BAKERSMAN
This is pulling the first alpha numeric value, is there a way to pull that
last value.
last value.
M
Max
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