| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
trouble with text lookup ... help please
Greetings, I have a list of the following format: L1-100001 L1-100002 L1-100003 L2-100001 L3-100001 L3-100002 L4-100001, etc. I need to find a way to extract from this list (with a cell formula or series of cell formulae) the highest index for a particular prefix (i.e. 100003 for L1, or 100002 for L2). I've tried so many different things and I just can't get any to work correctly. I'm familiar with arrays, and VLOOKUP and so forth but I must be doing something wrong. I am blowing the budget on this task and I really need to move on ... please help. TIA William DeLeo -- William DeLeo ------------------------------------------------------------------------ William DeLeo's Profile: http://www.excelforum.com/member.php...fo&userid=1256 View this thread: http://www.excelforum.com/showthread...hreadid=550365 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| I want to customize a text depending of anwers in a lookup table | Excel Worksheet Functions | |||
| Lookup Text in Comments | Excel Worksheet Functions | |||
| Autofitting a row | Excel Discussion (Misc queries) | |||
| Sort or Filter option? | Excel Worksheet Functions | |||
Threaded Mode
