| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Max number in a given range
welcome
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "pcor" wrote in message ... Thanks you very much |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Does a number exist in a range | Excel Worksheet Functions | |||
| Last Row Number in a Named Range | Excel Worksheet Functions | |||
| End of range changes when I add a number | New Users to Excel | |||
| Searching a Range for a number over 40 | Excel Worksheet Functions | |||
| Assign one number to a number range | New Users to Excel | |||
Linear Mode
