|
|
|
|
#1
09-11-2014, 04:09 PM
|
|||
|
|||
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. 
|
|
|
|
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 |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode