Max number in a given range

  • Thread starter Thread starter pcor
  • Start date Start date
P

pcor

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
 
MAX(the highest) number between row 1 and 10
In say, F1: =MAX(E1:E10)

If you mean comparing just 2 cells, E1 and E10.
then in F1: =MAX(E1,E10)
 
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))
 
Thanks

Don Guillett said:
Forgive me, but have you looked in the help index for MAX

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
Click to expand...
 
You were the most helpful by far Most sincere thanks...and BTW it worked
very well
Thanksagain
 
Back
Top