LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
gkaste
 
Posts: n/a
Default calculating in a changing range


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you copy RANK w/o it changing the range? jspan Excel Worksheet Functions 1 June 21st 05 02:56 AM
monitoring a changing range of cells kevin Excel Discussion (Misc queries) 1 June 3rd 05 05:39 PM
monitoring a changing range of cells Kevin Excel Worksheet Functions 1 June 3rd 05 04:54 PM
Changing a range of an array in a SUMPRODUCT formula gives a #N/A error Chrism Excel Discussion (Misc queries) 4 May 4th 05 04:06 PM
changing a range of fields Mr. G. Excel Discussion (Misc queries) 3 January 31st 05 09:21 PM


All times are GMT +1. The time now is 05:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"