Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ranking names
I have a list a1.a1000 first names, b1.b1000 last names, that are sometimes
duplicative, sometimes not: A B Joe Smith Joe Smith Joe Jones Frank Jones Sally Doe I want to sort these in rank order with a second column (D) that shows how many times they show up: C D Joe Smith 2 Joe Jones 1 Frank Jones 1 etc. Thank you Dave |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NAMES DEFINED | Excel Discussion (Misc queries) | |||
Have 2 columns of names - need to filter out names not duplicated | Excel Worksheet Functions | |||
copying cell names | Excel Discussion (Misc queries) | |||
Replace range names with cell references? | Excel Worksheet Functions | |||
Finding Duplicate Names from Different Lists... | Excel Discussion (Misc queries) |