Attached is a sample file with 3 worksheets. The worksheet, Strings of Interest, has a list of strings that I need to get counts of from the data in the worksheet, Raw Data. I'd like to have a third worksheet like what I'm showing in this file as the sheet, Summary Data. The Summary Data sheet shows the number of occurrences of each String of Interest in the Raw Data sheet.
I know how to create a helper column to count for each unique value, and to then sum all the occurrences, but that feels inefficient. My Raw Data sheet could have anywhere from 500 records, to 40,000 records. My "Strings of Interest" could change somewhat frequently over time. I have lots of files in which I need to do this same thing.
What is a better/more efficient way to do what I'm trying to do?
Bookmarks