Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I sort a list of names
I have a list of names in a spreadsheet. I want to know how do I sort these
names in number of occurances i.e if "Fred" occurs 7 times in a list of 50, I want it to tell me in specific cells " Fred 7 ", "Jack 6", "Alison 6 ", "Mary 5" etc. Any help will be most appretiated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I sort a list of names
Click DATA in the menu & select SORT. In the dialog box select the name
field as the sort field and click OK. Then click on DATA in the menu and select SUBTOTALS. In the dialog box select the name field from the combobox list for AT EACH CHANGE IN, select COUNT as the function to use from the USE FUNCTION combobox and check off the name field in the ADD SUBTOTAL TO list box & click OK. Counts appear after each name grouping right below the name field -- Kevin Backmann "neilb514" wrote: I have a list of names in a spreadsheet. I want to know how do I sort these names in number of occurances i.e if "Fred" occurs 7 times in a list of 50, I want it to tell me in specific cells " Fred 7 ", "Jack 6", "Alison 6 ", "Mary 5" etc. Any help will be most appretiated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create a random list of names from a list of names in EXCEL | Excel Worksheet Functions | |||
List of names sort | Excel Discussion (Misc queries) | |||
How do I randomly sort a list of names? | Excel Discussion (Misc queries) | |||
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 |