MAX function and "visible cells only"

[beluga]

Hi,

I want a cell to reflect the MAX value in a column from a list that has been filtered. Using MAX() the usual way will give me the maximun value of all data (filtered and unfiltered). How can I get the MAX() value of only the visible cells?

thanx in advance

 

[Frank Kabel]

Hi
have a look at the SUBTOTAL function. e,.g.
=SUBTOTAL(4,A1:A100)

-----Original Message-----
Hi,

I want a cell to reflect the MAX value in a column from a

list that has been filtered. Using MAX() the usual way
will give me the maximun value of all data (filtered and
unfiltered). How can I get the MAX() value of only the
visible cells??

 

[Jerry W. Lewis]

=MAX(IsVisible(range))
array entered (Ctrl-Shift-Enter) and using my IsVisible VBA function
http://groups.google.com/groups?selm=3F6073FD.1000108@no_e-mail.com

Jerry