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