How to know if a value passes a filter in a formula?

[Regina]

Hi Rob,

if you filter using an Autofilter, then you can use function
  SUBTOTAL(4;<Range>)
instead of MAX. See help on SUBTOTAL.

Kind regards
Regina

Rob Jasper schrieb:

[Rob_Jasper]

Regina,

Thanks for the help, works like a charm.
And yes, I've now read the full help of SUBTOTAL() and I see all kind of uses

Thanks again,

Rob.