How to count text as a number - Exclude duplicates

[Lmaonade]

This is probably very simple for most people but I want to have a total number of names from a list but if the name comes up more than once I only want to count it once.

For example:

[TABLE="width: 128"]
<tbody>[TR]
[TD="width: 64"][TABLE="width: 128"]
<tbody>[TR]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"]A[/TD]
[/TR]
[TR]
[TD="class: xl65"]1[/TD]
[TD]Ryan[/TD]
[/TR]
[TR]
[TD="class: xl65"]2[/TD]
[TD]Bob[/TD]
[/TR]
[TR]
[TD="class: xl65"]3[/TD]
[TD]Jim[/TD]
[/TR]
[TR]
[TD="class: xl65"]4[/TD]
[TD]Dan[/TD]
[/TR]
[TR]
[TD="class: xl65"]5[/TD]
[TD]Andy[/TD]
[/TR]
[TR]
[TD="class: xl65"]6[/TD]
[TD]Luke[/TD]
[/TR]
[TR]
[TD="class: xl65"]7[/TD]
[TD]Peter[/TD]
[/TR]
[TR]
[TD="class: xl65"]8[/TD]
[TD]Ryan[/TD]
[/TR]
[TR]
[TD="class: xl65"]9[/TD]
[TD]Andy[/TD]
[/TR]
[TR]
[TD="class: xl65"]10[/TD]
[TD]Stephen[/TD]
[/TR]
[TR]
[TD="class: xl65"]11[/TD]
[TD]Mike[/TD]
[/TR]
[TR]
[TD="class: xl65"]12[/TD]
[TD]Mike[/TD]
[/TR]
[TR]
[TD="class: xl65"]13[/TD]
[TD]Eddy[/TD]
[/TR]
[TR]
[TD="class: xl65"]14[/TD]
[TD]Jim[/TD]
[/TR]
[TR]
[TD="class: xl65"]15[/TD]
[TD]Paul[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="width: 64"][/TD]
[/TR]
</tbody>[/TABLE]


I want a formula in another cell to count total number of people. So I'd want it the answer to return 11 as there are 11 unique names.

Thanks,
Andy

 

[njimack]

=sumproduct(1/countif(a1:a15,a1:a15))

 

[Lmaonade]

Hi njimack,

Thanks a lot! This works! BUT, I also have some blanks in my spreadsheet which will be filled in as time goes on. Is there a way to have it disregard blanks, otherwise I get an error return (#DIV/0!)

 

[Aladin Akyurek]

Control+shift+enter, not just enter:

=SUM(IF(FREQUENCY(IF(1-($A$1:$A$15=""),MATCH($A$1:$A$15,$A$1:$A$15,0)),ROW($A$1:$A$15)-ROW($A$1)+1),1))
​

which is by far the most efficient formula for unique counting.
​