View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Matt Stayton Matt Stayton is offline
external usenet poster
 
Posts: 1
Default finding n-th most frequently occuring word

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!