![]() |
|
#1
|
|||
|
|||
|
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. |
| Thread Tools | |
| Display Modes | |
|
|
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 values that match 2 or more criteria
|
caeiro01 | Excel | 1 | 10-25-2015 02:34 AM |
Display unique values and count the number of child items
|
vthomeschoolmom | Excel | 2 | 07-25-2013 06:17 AM |