Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
top 10 for text?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
top 10 for text?
See this:
http://tinyurl.com/2gq3td -- Biff Microsoft Excel MVP "hitekredneck" wrote in message oups.com... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
top 10 for text?
"hitekredneck" wrote: 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. hope that helps |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
grab cell text from multi-tab workbook, show text in another workb | Excel Worksheet Functions | |||
Text does not display in "Text boxs" and when wrapping text in a c | Excel Discussion (Misc queries) | |||
Text not continuing to wrap for large block of text in Excel cell | Charts and Charting in Excel | |||
merged cells into one text cell, size varies dependant on text dat | Excel Discussion (Misc queries) | |||
text (3750 char.)truncates with text wrap and row heigh adjusted? | Excel Discussion (Misc queries) |