View Single Post
 
Old 09-11-2014, 04:09 PM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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.
Reply With Quote