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