Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 01-19-2023, 04:13 AM
Debaser's Avatar
Debaser Debaser is offline returns ALL values which start with... Windows 10 returns ALL values which start with... Office 2016
Competent Performer
 
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default

Cross-posted: returns ALL values which start with...
Reply With Quote
  #3  
Old 01-19-2023, 04:28 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline returns ALL values which start with... Windows 10 returns ALL values which start with... Office 2021
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

@dal109
Please read A message to forum cross posters - Excelguru to understand why posting links to cross posts is important
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Thread Tools
Display Modes


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 02:39 PM.


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