View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default Max number in a given range

Hi

Not sure what you mean.
Do you want the max number between E1and E10
=MAX(E1:E10)
or MAX(E12:E22)
or the maximum of E1:E22 but excluding E11
=MAX(MAX(E1:E10),MAX(E12:E22))
--
Regards
Roger Govier

"pcor" wrote in message
...
In col E I have numbers from row 1 to row 22
How do I find out the MAX(the highest) number between row 1 and 10 or row
12
and 22
Thanks