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 !!

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 !!