returns ALL values which start with...
Hi all,
I have the list of unique numbers below, where the first portion (8 numbers) may vary, while the last one is unique.
The list of number is very long and I usually I only know the first 8 numbers, while the last 6 (like it could be 300-006) are unknown. I need to create a quick reference in another worksheet, where I can input the first 8 numbers and the worksheet returns all the possible values (not only the first one) that start with those 8 numbers that I have in the column "Tracking number".
Could anyone guide me through the most efficient way to do so?
Thank you
TRACKING_NUMBER
42379114-200-001
42379722-100-001
42379805-100-001
42375578-100-001
42377607-100-001
42376184-100-001
42377880-100-001
42375146-100-001
42362211-100-001
42360608-200-001
42360633-200-001
42375633-100-001
42351694-100-001
42351120-100-001
42355121-100-002
42355121-100-001
42355118-100-001
42354487-100-002
42354487-100-001
42354926-100-001
42335283-100-001
42320073-100-001
etc.
|