Sorry, i entered the incorrect array formula, my formula for the top most
frequent is ACTUALLY

=INDEX(rng,MATCH(MAX(COUNTIF(rng,rng)),COUNTIF(rng ),0))

"Matt Stayton" wrote:

I am trying to find the n-th most frequently occurring name is a database. I
have a formula that finds the top most frequently occurring name
=INDEX(rng,MATCH(LARGE(UNIQUEVALUES(COUNTIF(rng,rn g)),2),COUNTIF(rng,rng),0))
this being entered as an array.

How would I find the second, third, fourth, etc. most frequently occurring
name?

Example:

George
Ilysha
Steven
George
Steven
George

Thanks!