MAX function and "visible cells only"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...
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??
 
Back
Top