Dear All
I am stuck with the filter function I do not know how to sort the data.
This is what I need:
1. System checks the Missed points section
2. System find the most repetitive text from the table
3. System sorts out the repetitive text per What section
4. Make a top 3 list of missed points per What section
So if text "a" appeared 5 times in the list under the Check in then it should go to the list "Top 3 missed for Check in"
For an example please see the excel document attached
Bookmarks