Count Unique Number Values When Data Filtered

[CaitCampLand]

I want to count the unique company IDs when the data in the table is filtered. Currently I am using this formula: =SUMPRODUCT(1/COUNTIF(A3:A42,A3:A42)). This works great but if I want to filter of course, it needs something else. I've tried several different options and am still at a loss. Hoping someone can help me here.

 

[Fluff]

You're welcome & thanks for the feedback.