Count unique names in a column

[HilaryPalmer]

I have a sheet with students details on and some of them appear more than once. All I want to be able to do is count the number of names that appear in the list excluding dupes ie if a column has Matthew, Mark, Luke, Luke, Luke and John then I just want it to count the number of unique names so the answer would be 4 in this case. I am sure it is a simple thing but I just cant figure it out! Can anyone help?

[Kaper]

Use:

Please Login or Register  to view this content.

adjust the formula to cover only range with names

[jasonmcasey]

Hi Hilary

You can use the following array formula (type it in the box and then press CTRL+SHIFT+ENTER and Excel will place { } curly brackets around it), where A1:A9 would need to be replaced with the range that includes your names.

Please Login or Register  to view this content.

[windy58]

Another array formula

=SUM(IF(FREQUENCY(IF(LEN(A1:A10)>0,MATCH(A1:A10,A1:A10,0),""), IF(LEN(A1:A10)>0,MATCH(A1:A10,A1:A10,0),""))>0,1))

[HilaryPalmer]

thanks you!! I knew I could count on all your expertise!! If only I knew how more........

[sktneer]

If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.

You may also say thanks to those who have put their time and efforts to help you in this forum by clicking the Add Reputation link under their posts, another way to say thanks.

[Ali Kırksekiz]

Alternative

Please Login or Register  to view this content.