AutoFilter - Number of rows removed?

[TAPS_MikeDion]

Hi everybody,

I'm using an AutoFilter to remove rows from view when there is an X in a specific column.

Since the number of rows doesn't actually change, they're just removed from view, it is possible to know how many lines were actually hidden without having to manually count the rows with X's in them?

Thanks!

 

[Fluff]

You could use countifs to count how many Xs there are.

 

[TAPS_MikeDion]

Yup, nice and easy. Thanks again Fluff.

 

[Fluff]

Glad to help & thanks for the feedback.