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.

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&""))

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1