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