Hello All,
I am currently using the following formula to count unique text values in a column.
=SUM(IF(FREQUENCY(MATCH(A2:A365,A2:A365,0),MATCH(A2:A365,A2:A365,0))>0,1))
However, when I filter the information in the column, the calculation remains the same. I'd like use a formula that counts unique texts values in only the visible range, similar to a subtotal function.
Please let me know if you can help!
Thanks,
Matt
Bookmarks