I am trying to find a way to sort/filter a pivot table column by most common/frequent "words".
For Example, I work in a a family clinic and patients could come in because "headache, head injury, head trauma, constant head ache, hit in head by object ...".
I want to find a way to count all instances that say "head".
Note - this also will apply for other "common" words, such as pain (ie. neck pain, back pain, foot pain etc)
Bookmarks