#1
|
|||
|
|||
Need a sort and index formula
I have a spreadsheet with names in column a. Many of the names are duplicates. What I am trying to do is find a way to sort them so that the names can be listed once with a corresponding number to the cell to the right telling me how many times the name is used.
Example: smith smith 4 jones jones 3 smith williams 2 smith Barns 1 jones jones Williams Barns Smith Williams Thanks |
#2
|
|||
|
|||
Copy the list to another column with an intervening blank column. Select that column and do Data:Remove Duplicates.
To the right of the first name in the now duplicate free column, enter the formula: =countif(a:a,c1) Copy the equation down to the end of the list. |
#3
|
||||
|
||||
And, of course you can use a Pivot Table
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need help with Index formula | gbaker | Excel | 7 | 02-07-2014 06:34 AM |
Complex Formula using INDEX and Match needed | OTPM | Excel | 5 | 05-23-2013 01:22 AM |
Help with multiple match and index formula | ryanwood | Excel | 1 | 09-12-2012 07:53 AM |
Sort Macros | boutells | Excel | 1 | 07-16-2009 11:48 AM |
Sort Range | boutells | Excel | 1 | 07-15-2009 03:02 AM |