Hello,
I am trying to find the most occurring text in my range.
This formula works well to find the most occurring text
=ARRAYFORMULA(INDEX(A1:A17,MATCH(MAX(COUNTIF(A1:A17,A1:A17)),COUNTIF(A1:A17,A1:A17),0)))
Now, I want to tweak the formula to find the second highest, third higest etc.
Please let me know.
Bookmarks