I am using this formula to Count the number of Distinct Entries In a column. But how do I get this formula to work with Auto filtered data? i just want to count the distinct entiries that are displayed and not the hidden ones-i dont want the formula to see the hidden rows.

Thanks.

=SUM(1/COUNTIF(A1:A100, A1:A100))
http://spreadsheetpage.com/index.php...es_in_a_range/