calc visible data only

[John]

It is possible to make functions calc the visable data only

For example I am running a autofilter across a set of data
I would like to determine the Max and Min of one of the variablbased on thefiltered results

Any ideas

John

 

[Harald Staff]

Hi John

=SUBTOTAL(4,A2:A300)
=SUBTOTAL(5,A2:A300)

 

[Frank Kabel]

Hi
have a look at the SUBTOTAL function for this