Most popular names in a list

  • Thread starter Thread starter cqmman
  • Start date Start date
C

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..
 
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
 
cqmman said:
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..
Click to expand...

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
 
Back
Top