Hey folks! I have kind of a unique scenario here that I could use some help with. Attached is a workbook where I mocked up an example that can be played with.
The issue is this:
aaaaaaa.JPG
I've been tasked to comb through a huge total of customer feedback notes and break these down by keyword. No biggie, I just set up a countifs statement, and that works great.
My issue occurs when a note has multiple keywords in it. For example, if my note is 'Make the box bigger.' and my keywords are 'box' and 'bigger', then the formulas I have set up will flag a "Match" for box and a "Match" for bigger. Thing is, when I have to add up the results of my work, the % exceeds 100, and I realized it's because I'm inadvertently counting the same note twice. So what I'm trying to do is tell my formula, "Hey, find this keyword and count the number of times it occurs, but if you find it in conjunction with another keyword, be sure to accommodate that in your final totals".
As I'm typing this I'm hoping that it makes at least a lick of sense because I'm having the hardest time explaining it right now.
Simplest I can think to put it right now is; does anyone know of a way to run a count on keywords that may overlap, but exclude instances that have already been counted once in the final totals?
Hopefully someone can make sense of my rambling. Thanks!
Bookmarks