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 |
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 |
All times are GMT +1. The time now is 03:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com