Finding maximum of various ranges of data

  • Thread starter Thread starter thekovinc
  • Start date Start date
T

thekovinc

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!
 
Without writing code, one possible- and unfortunately, manual- way to
do this is to use the Sigma button on the tool bar in each blank space.
That will create a SUM() formula that considers the contiguous cells
immediately adjacent to the cell pointer. Then do a search-and-replace
on that column: search for SUM, replace with MAX.
 
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!
Click to expand...

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
 
Back
Top