Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Maximum
Good morning, (or it is here!)
Using MAX() I am able to find the maximum number in a given column. How would this be adapted to find the maximum number between a given range of numbers, say 1000-1099, 2000-2009, if the columns conatined numbers between 0 and 1 million? Yours in appreciation, Neil |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Maximum
.. find the maximum number between a given range of numbers,
say 1000-1099 Assuming the source data range is A1:A10 one way is to use this in say B1, array-entered ie press CTRL+SHIFT+ENTER to confirm the formula (instead of just pressing ENTER): =MAX(IF((A1:A10=1000)*(A1:A10<2000),A1:A10)) voila? punch the YES below -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "Neil Pearce" wrote: Good morning, (or it is here!) Using MAX() I am able to find the maximum number in a given column. How would this be adapted to find the maximum number between a given range of numbers, say 1000-1099, 2000-2009, if the columns conatined numbers between 0 and 1 million? Yours in appreciation, Neil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maximum value | Excel Discussion (Misc queries) | |||
Return Maximum from Column directly above Maximum in Row | Charts and Charting in Excel | |||
maximum | Excel Worksheet Functions | |||
Maximum | Excel Worksheet Functions | |||
Specify Maximum Value | Excel Discussion (Misc queries) |