top 10 for text?

  • Thread starter Thread starter hitekredneck
  • Start date Start date
H

hitekredneck

I have a spreadsheet in which one of the columns is peoples name. I
need to find out what names appear the most. Since the top 10 doesn't
work with text, can someone please tell me how to do this with text?

Thanks
Mark
 
hitekredneck said:
I have a spreadsheet in which one of the columns is peoples name. I
need to find out what names appear the most. Since the top 10 doesn't
work with text, can someone please tell me how to do this with text?

Thanks
Mark

what I would do is create a Pivot table, put the field name for "name" on the left and at the same time put it in the "data" section and do a COUNT OF instead of sum of. this will count the number of times that name appears.
Click to expand...

hope that helps
 
Back
Top