Max number in a given range

[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

 

[Don Guillett]

Forgive me, but have you looked in the help index for MAX

 

[Max]

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)

 

[Roger Govier]

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))

 

[pcor]

Thanks you very much

In say, F1: =MAX(E1:E10)

If you mean comparing just 2 cells, E1 and E10.
then in F1: =MAX(E1,E10)

 

[pcor]

Thanks

Forgive me, but have you looked in the help index for MAX

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

 

[pcor]

You were the most helpful by far Most sincere thanks...and BTW it worked
very well
Thanksagain

 

[Max]

welcome