I need to know the top 3 items. I've found the formula for the most common item, and how to count the number of that item, but not how to find the second and third most common item.



=INDEX(Report!A1:A57,MODE(MATCH(Report!A1:A57,Repo rt!A1:A57,0)))
=COUNTIF(Report!A:A, "*"&E4&"*")


Attached is a mock worksheet. One issue is the INDEX formula doesn't work if a blank cell is selected and the total number of items changes day to day. The most common items change day to day as well. I keep thinking there's a =LARGE formula that can be added or something, but I can't find an example to work off of.

Attached Files

MsForums.xlsx (14.3 KB, 9 views)