Most popular names in a list
 

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..

Most popular names in a list
 

Hi cqmman,

Say your list is in column A
Select all of your data
Go to DataFilterAdvanced 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" wrote in message
ups.com...
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..

Most popular names in a list
 

"cqmman" wrote in message
ups.com...
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