Max number in a given range
 

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 number in a given range
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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

Max number in a given range
 

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)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"pcor" wrote:
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 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

Max number in a given range
 

Thanks you very much
"Max" wrote:

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)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"pcor" wrote:
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 number in a given range
 

Thanks

"Don Guillett" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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

Max number in a given range
 

You were the most helpful by far Most sincere thanks...and BTW it worked
very well
Thanksagain
"Roger Govier" wrote:

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

Max number in a given range
 

welcome
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"pcor" wrote in message
...

Thanks you very much