Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-03-2020, 04:21 PM
robnun robnun is offline Count Unique Instances of Multiple Strings Using Wildcards Windows 10 Count Unique Instances of Multiple Strings Using Wildcards Office 2019
Novice
Count Unique Instances of Multiple Strings Using Wildcards
 
Join Date: Dec 2020
Location: TX, USA
Posts: 8
robnun is on a distinguished road
Default Count Unique Instances of Multiple Strings Using Wildcards

I am looking for a macro that will count the unique instances of multiple strings, and the find function requires wild cards.

Example: Assume the text in the Word document is: PE-15896 Blue lamps from China. PE-12 Green buckets from India. JEB-85968 Green cans from Mexico. HEL-698568 Orange phones from Peru. HEL-698568 Red boxes from Canada. (Notice HEL-698568 is used twice - this should be counted as one instance)
I need to count all instances of strings that start with PE-,HEL-, and JEB- and have any number of characters after the dash.

I need to generate the following:
PE-15896
PE-12


JEB-85968
HEL-698568
Total Unique Records = 4

Thank you!

Last edited by robnun; 12-03-2020 at 06:53 PM.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Function To Count All Strings In Range Pluviophile Excel 1 09-21-2020 06:22 PM
Calculate recurring instances between cell count - using trigger - URGENT HELP sfarad Excel Programming 2 07-07-2018 07:59 AM
Count Duplicate Values without a specific Unique Value Brittni Excel 1 02-01-2017 06:22 PM
Count Unique Instances of Multiple Strings Using Wildcards Count unique values that match 2 or more criteria caeiro01 Excel 1 10-25-2015 02:34 AM
Count Unique Instances of Multiple Strings Using Wildcards Display unique values and count the number of child items vthomeschoolmom Excel 2 07-25-2013 06:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:26 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