How do I extract top 3 most frequent in a list?

I have a column of names of people who have logged calls within a period. Some of these names obviously pop up more than once and I am wanting to report on those top 3 people who have logged calls in that period.

In short, I want the top 3 most frequent in a list.

What function would I use to do this?

Thanks

hi fuzzyfreak,

if you already have a list of names in column A and in B1 a name you need to check against put in C1:-

=COUNTIF($A$1:$A$100,B1)

this will give you the number of occurrences that it appears in the list, then you can place the other names in the B column and drag the formula down.

thanks reg

Hi Reg, thanks very much for your reply. I got a similar one on another forum and I am working on it for my needs. If I need any further help, I'll let you know.

Kind Regards,

Tim.