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))
Hi Detlef, thanks for reply. I'm a novice at Excel and have no knowledge of the functions you've suggested.