![]() |
#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 | 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 |
![]() |
caeiro01 | Excel | 1 | 10-25-2015 02:34 AM |
![]() |
vthomeschoolmom | Excel | 2 | 07-25-2013 06:17 AM |