Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() I am trying to find a maximum value in a range that will be changing (in starting position, and length). Here is an example, this is cells A1 to A13: 2 1 0 1 2 3 4 3 2 1 0 1 2 I want to find the max between zero points (In this case, there would be one max, and it would be 4). The number of zero points and the number of cells between them will change. Anyone have some idea of how to go about this, or anything to even get me started? Thank you! -- gkaste ------------------------------------------------------------------------ gkaste's Profile: http://www.excelforum.com/member.php...o&userid=24525 View this thread: http://www.excelforum.com/showthread...hreadid=392715 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do you copy RANK w/o it changing the range? | Excel Worksheet Functions | |||
monitoring a changing range of cells | Excel Discussion (Misc queries) | |||
monitoring a changing range of cells | Excel Worksheet Functions | |||
Changing a range of an array in a SUMPRODUCT formula gives a #N/A error | Excel Discussion (Misc queries) | |||
changing a range of fields | Excel Discussion (Misc queries) |