Hi all -
This is a continuation of a prior 'solved' problem (thank you Haseeb A!). I've now been asked to provide a further data parse and I think I'm going to have to use VB to get it - and those skills of mine are old!
The data is proprietary, so I can't share it. I'm going to attach a fake dummied up version. Essentially, here's the skinny:
Column A has the name of a person. Columns B thru D have string data with a keyword buried in it, such as Steel Support Beam ("support" is the keyword), Driver Clamp ("clamp" is the keyword). This string data may recur in a row, but I only need to count the occurrence of the string once. I have a formula that performs the count already, thanks to a previous posting on this forum. The new wrinkle: In addition to the count of the individual strings, I now need to know the count of occurrences of each keyword per person.
In essense:
Joe: Support = 2
Clamp = 3
The dummy sheet I've attached tries to show this, and show the data I'm after. I'm happy to do a script but, as I say, those skills are old - so I could use some help!
Happy to provide further explanation if needed. Thanks much!
Rachel
EDIT: I'm quite comfortable with Pivot tables, but I've yet to see a way to search for a string via Pivot table. If the resulting output from a vb script does nothing more than give a listing of the person's name, and then a listing of the keyword next to it, that's fine. I can turn that into a pivot table.
Bookmarks