| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup criteria - digits and letter
Hello !
Having an issue with the organization of the array table. A few of the 7 digit resource numbers - the sort criteria - end with "-C". 0100000 0100000-C 0200000 0200000-C chrono order isnt working for me, I have tried eliminating the dash, and putting the "C" items at the end of the chrono . Does anyone have a suggestion ? Thanks for your time and expertise !! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lookup criteria - digits and letter
Cindy,
What is it that you are trying to do? Sort, or use the table in a LOOKUP or VLOOKUP? HTH, Bernie MS Excel MVP "cindyk" wrote in message ... Hello ! Having an issue with the organization of the array table. A few of the 7 digit resource numbers - the sort criteria - end with "-C". 0100000 0100000-C 0200000 0200000-C chrono order isnt working for me, I have tried eliminating the dash, and putting the "C" items at the end of the chrono . Does anyone have a suggestion ? Thanks for your time and expertise !! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup between sheets, finding a match, and returning a letter | Excel Worksheet Functions | |||
| Matrix lookup/mulitple criteria lookup | Excel Discussion (Misc queries) | |||
| sum number of cells based on letter/title criteria | Excel Worksheet Functions | |||
| Varying left criteria based on 1st Letter....If Function? | Excel Discussion (Misc queries) | |||
| Lookup the 1st 5 digits | Excel Worksheet Functions | |||
Linear Mode
