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.