Forum Discussion
Solved
Excel - List of Unique Names?
Hi, I'm a relative novice with Excel. I have a column of hundreds of names - many of which are duplicated. Both the first name and surname are in the same cell in one long column. Is ther...
Does this formula work for you? It doesn't use functions that are only available in recent versions of Excel.
=SUMPRODUCT((C4:C641<>"")/COUNTIF(C4:C641,""&C4:C641))
or (confirmed by pressing Control+Shift+Return or Command+Return):
=SUM(IF(FREQUENCY(IF(C4:C641<>"",MATCH(C4:C641,C4:C641,0)),ROW(C4:C641)-ROW(C4)+1),1))
Thanks to everyone who has replied to my original question. Great to have input from everyone. Problem has been resolved by Hans in one of the replies
=SUMPRODUCT((C4:C641<>"")/COUNTIF(C4:C641,""&C4:C641))
=SUMPRODUCT((C4:C641<>"")/COUNTIF(C4:C641,""&C4:C641))