Top Text Entries in a Range - Only shows repeated values + possible extra condition

Hi I have this formula which works great if I want to list the most common repeated values in a range providing there is more than one entry

{=LOOKUP(REPT("Z",255),CHOOSE({1,2},"",INDEX(Feedback_Category,MODE(IF((Feedback_Category<>"")*ISNA(MATCH(Feedback_Category,$B$21:$B21,0)),MATCH(Feedback_Category,Feedback_Category,0))))))}

[Feedback_Category:]
Procedures Not Followed
Problem Took Too Long to Resolve
Procedures Not Followed
Procedures Not Followed
Procedures Not Followed
Positive Comments Received
Positice Commends Received

However I would also like to list an entry if it doesn't repeat - e.g. "Problem Took Too Long to Resolve"

Can someone help me as I don't understand the above formula.

Also if possible but I appreciate I may be asking for too much, I have named cell "Selection_Team" and range "Team_Name"

I would like to add to the formula a way of filtering it down to each team selection - I tried doing this but it doesn't work:

{=LOOKUP(REPT("Z",255),CHOOSE({1,2},"",INDEX(Feedback_Category,MODE(IF((Feedback_Category<>"")*ISNA(MATCH(Feedback_Category&Selection_Team,$B$21:$B21&Team_Name,0)),MATCH(Feedback_Category&Selection_Team,Feedback_Category&Team_Name,0))))))}

Thanks for any help on this one

For the first, the issue is the CHOOSE. if theres only 1 entry (choose 1), it ends up blank, if theres 2 or more, it runs the formula. So if you remove the choose section entirely that will fix it.

Please Login or Register  to view this content.

For your second problem, Feedback_Category is a named range. Use CTRL+F3 to modify, or create a new range. You want to replace the range with that of your Selection Team and Team Name.

Hi and thanks for taking the time to reply. I tried the formula but it returns #N/A and only the first top common text entry.

My apologies but I am not sure what you mean in regards to the feedback_category named range? this range is the value i want to return but only for those entried which match the specified team_selection value.

Have you confirmed the formula with CSE? Just making sure.

If so, can you post the workbook?

Attached is a sample as requested - thanks for your help

I've been trying to crack that code for a while now and all I could figure is that the CHOOSE part is OK and doesn't need to be changed and it is down to how it calculates the MODE using ISNA and multiplication.
Sorry