| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup the last alpha numeric value in a column
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lookup the last alpha numeric value in a column
Try this:
=LOOKUP(REPT("Z",255),A:A) Assumes there are no formula blanks (empty TEXT strings) within the range. -- Biff Microsoft Excel MVP "BAKERSMAN" wrote in message ... 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lookup the last alpha numeric value in a column
Please refrain from posting the same question more than once
-- Regards, Peo Sjoblom "BAKERSMAN" wrote in message ... 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lookup the last alpha numeric value in a column
Worked perfectly!! Thanks!
"T. Valko" wrote: Try this: =LOOKUP(REPT("Z",255),A:A) Assumes there are no formula blanks (empty TEXT strings) within the range. -- Biff Microsoft Excel MVP "BAKERSMAN" wrote in message ... 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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lookup the last alpha numeric value in a column
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "BAKERSMAN" wrote in message ... Worked perfectly!! Thanks! "T. Valko" wrote: Try this: =LOOKUP(REPT("Z",255),A:A) Assumes there are no formula blanks (empty TEXT strings) within the range. -- Biff Microsoft Excel MVP "BAKERSMAN" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change numeric column designations to alpha? | Excel Discussion (Misc queries) | |||
| How can I change my column references from Alpha to Numeric? | Excel Worksheet Functions | |||
| Change the column designation from a numeric to an alpha | Excel Discussion (Misc queries) | |||
| Excel XP. column headings are numeric I want alpha | Setting up and Configuration of Excel | |||
| column changed from alpha to numeric | Excel Worksheet Functions | |||
Linear Mode
