Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-19-2023, 02:57 AM
dal109 dal109 is offline returns ALL values which start with... Windows 10 returns ALL values which start with... Office 2019
Novice
returns ALL values which start with...
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
returns ALL values which start with... VBA to identify alpha numeric values in a word document and create a list of those values olson.jacob720 Word VBA 0 04-18-2022 10:44 AM
Table with values from several locations and years - need to find comp values Ricardo Sousa Excel 9 07-27-2018 02:06 AM
returns ALL values which start with... Table with values from several locations and years - need to find comp values Ricardo Sousa Excel 6 06-09-2018 10:51 PM
Display multiple values as new values based on selection from template. MvdB Excel 2 09-29-2015 08:51 PM
difference between scheduled start and start ketanco Project 3 01-15-2015 07:53 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:59 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft