Maximum

[Neil Pearce]

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

 

[Max]

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