|
|
#3
03-09-2017, 12:11 PM
|
|||
|
|||
hi! No I cannot just use sort because it will use any length of ID numbers with those two digits, not just the ones with the two digits as first two in ID number.
For example, if I searched for "15", it could show results like "15", "151", but also "4615" or "321516" which the two digits are contained in the ID number but not the first two digits. I can send a spreadsheet if easier? 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Need a formula (possibly something like VLOOKUP) that will return multiple results. | SilverUnicorn79 | Excel | 8 | 08-16-2016 01:34 PM |
 A challenging digit by digit manipulation, rotate the digit in range of 0 to 9
|
laucn | Excel Programming | 14 | 05-17-2015 12:12 PM |
| excel vlookup with multiple criteria | mpokorny | Excel | 4 | 05-06-2012 04:06 AM |
|
Vlookup or Index/Match - Multiple Criteria
|
ruci1225 | Excel | 1 | 01-15-2012 07:31 AM |
| Sum Product Multiple Text and date Criteria | ramki | Excel | 1 | 01-09-2012 01:16 AM |
Windows 7 32bit 
Office 2013
Threaded Mode