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
|