If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Finding maximum of various ranges of data
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 |
#2
|
|||
|
|||
Finding maximum of various ranges of data
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. |
#3
|
|||
|
|||
Finding maximum of various ranges of data
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
cross office program data sharing | m_jurrens | General Discussion | 0 | December 16th, 2005 03:36 PM |
Microsoft Office should use an advance data crosslinking model | m_jurrens | General Discussions | 0 | December 15th, 2005 07:33 AM |
Help PLEASE! Not sure what answer is: Match? Index? Other? | baz | Worksheet Functions | 7 | September 3rd, 2005 03:47 PM |
Sort pages? | David | General Discussion | 15 | May 13th, 2005 11:33 PM |
Charting data ranges that change | mikelee101 | Charts and Charting | 2 | December 16th, 2004 11:07 PM |