# Is there a formula that returns the number of unique text values in an array?

1. ## Is there a formula that returns the number of unique text values in an array?

Hi again,

As the thread title - say I had an array, column A rows 1-10. In the 10 cells the individual text values A, B, and C were entered in a random order for example B, C, C, B, B, A, B, C, A, C. Is there a formula that will return the value "3", the total of unique text entries?

Thanks.  Register To Reply

2. Originally Posted by theGFB
Hi again,

As the thread title - say I had an array, column A rows 1-10. In the 10 cells the individual text values A, B, and C were entered in a random order for example B, C, C, B, B, A, B, C, A, C. Is there a formula that will return the value "3", the total of unique text entries?

Thanks.
Give this a try,
=SUMPRODUCT((A1:A100<>"")/COUNTIF(A1:A100,A1:A100&""))  Register To Reply

3. Thanks that's great. I have actually used that method before in some on time/in full statistics but forgot about it   Register To Reply