Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting and matching rows of names with Socials with master list and eliminating the extra names | Excel Worksheet Functions | |||
create a random list of names from a list of names in EXCEL | Excel Worksheet Functions | |||
Most popular items in a list | Excel Worksheet Functions | |||
filter 400 names from list 1 from list 2 with 4000 names | Excel Worksheet Functions | |||
find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions |