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.
Bookmarks