| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup the last alpha numeric value
I need to look up the last alpha numeric value in a row.
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 --- |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup the last alpha numeric value in a column | Excel Discussion (Misc queries) | |||
| Alpha Numeric tab not showing only numeric. | Excel Worksheet Functions | |||
| only extract numeric value from alpha numeric cell | Excel Discussion (Misc queries) | |||
| +1, Alpha *and* Numeric | Excel Worksheet Functions | |||
| The colums changed from alpha to numeric how do you make it alpha | Excel Discussion (Misc queries) | |||
Linear Mode
