View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bill Ridgeway Bill Ridgeway is offline
external usenet poster
 
Posts: 268
Default 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