Hi all,
This seems simple enough but I'm having trouble finding this solution anywhere. I have a table column populated with data values that can repeat. I can extract these unique values in an array formula using:
Which will produce a list of all the unique values, excluding repeats. Is there any way I can determine the total number of unique values? For instance, say the above formula returns 54 rows of unique values. Is there a formula that will return the number 54?
Thanks so much in advance!
Bookmarks