View Single Post
 
Old 01-19-2023, 02:57 AM
dal109 dal109 is offline Windows 10 Office 2019
Novice
 
Join Date: Jan 2023
Posts: 1
dal109 is on a distinguished road
Default 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.
Reply With Quote