How can I return the second most frequent text in a column?

I know that I can find the most frequent text in A2:A60 by using =INDEX(A2:A60;MODE(MATCH(A2:A60;A2:A60;0)))

CodePudding user response：

Try:

Formula in B1:

=INDEX(SORTBY(UNIQUE(A1:A9),COUNTIF(A1:A9,UNIQUE(A1:A9)),-1),2)

Note that this will currently return the 2nd row from the array even if there is a tie.