Hi, I have a spreadsheet where I am trying to find the maximum value of
many different ranges of numbers (one maximum for each range). It is
set up like:

2
4
9
3
4
__
1
2
7
__
8
3
__

...and so on, where __ is the cell I would like to calculate the
maximum for (the three __ cells would have 9, 7, and 8 as their
respective maximums). Is there any way to have a formula I could
enter for these? Or will I have to manually enter a formula into each
individual cell I'm calculating a maximum for? (I have about 1000 of
these to calculate)

Also, each set of numbers has other indentifying criteria in other
cells so I would be able to use functions that would need other
information to determine the range.

Thanks!


--
thekovinc
------------------------------------------------------------------------
thekovinc's Profile: http://www.excelforum.com/member.php...o&userid=29378
View this thread: http://www.excelforum.com/showthread...hreadid=504172