Most popular names in a list

[cqmman]

Hello,

I have a sheet with a list of names. How would I go about returning
the most popular names on a different sheet? I would like it in a
table rather than graph format if possible..

 

[MartinW]

Hi cqmman,

Say your list is in column A
Select all of your data
Go to Data>Filter>Advanced Filter
Check copy to another location
In the copy to: box put $B$1
Check unique values only and OK out
Then in C1 put =COUNTIF(A:A,B1)
Click on C1 and double click on the fill handle.

HTH
Martin

 

[Bill Ridgeway]

Hello,

I have a sheet with a list of names. How would I go about returning
the most popular names on a different sheet? I would like it in a
table rather than graph format if possible..

A Pivot Table would do that. Click on <Data><Pivot Table and Pivot Chart
Report> and follow the prompts. Setting up a Pivot table isn't the most
intuitive job but time spent on setting one up is rewarded by time saved
later on - and you'll learn how to for another occasion.

Bill Ridgeway