On Mon, 23 Jan 2006 14:14:00 -0600, thekovinc
wrote:


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!

Is there something in other cells in the same row that would allow you to group
these ranges?

In other words, if all in the first segment were of Type A, second segment Type
B, and so forth, you could sort by type, and then use the Data/Subtotals
wizard; or you might be able to use a Pivot Table.

--ron