Hi!

Ok, this is a separate formula and works on the selected zero points in
reverse order: ie- 3:1.

Again, use 2 cells to hold the range of interest:

E2 = 3
F2 = 1

Array entered:

=MAX(IF(A1=0,0,OFFSET(A1,,,SMALL(IF(A1:A18=0,ROW(A1:A18)),F1)-1)),INDIRECT("A"&SMALL(IF(A1:A18=0,ROW(A1:A18)),E1)+1&":A"&MAX(IF(A1:A18<>"",ROW(A1:A18)))))

Biff

"Biff" <biffinpitt@comcast.net> wrote in message
news:OebbisemFHA.1204@TK2MSFTNGP12.phx.gbl...
> Yow!
>
> That will be extremely difficult (if at all possible) to do in a single
> formula. Let me tinker around and see if I can come up with something. It
> may take a separate formula to check from zp 3 to zp 1.
>
> Biff
>
> "gkaste" <gkaste.1tawii_1123261515.8444@excelforum-nospam.com> wrote in
> message news:gkaste.1tawii_1123261515.8444@excelforum-nospam.com...
>>
>> Biff, thank you very much for the help. That worked excecllent!
>>
>> I do, however, have one more situation that this dosent test for, that
>> I would appreciate some help with. Here is some example data:
>>
>> 1
>> 0 <-zero 1
>> 1
>> 2
>> 3
>> 2
>> 1
>> 0 <-zero 2
>> 1
>> 2
>> 3
>> 2
>> 1
>> 0 <- zero 3
>> 1
>> 2
>> 3
>> 2
>>
>> I can use the formula above to find the max between zero 1 and 2, 2 and
>> 3, but, this data is actually data on a circle(example: first cell is a
>> recording at 0 degrees, and the last cell is a recording 359.9
>> degrees), so, is there a way to find the max between zero 3 and zero
>> 1?
>>
>> Thank you,
>> Garrett
>>
>>
>> --
>> gkaste
>> ------------------------------------------------------------------------
>> gkaste's Profile:
>> http://www.excelforum.com/member.php...o&userid=24525
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=392715
>>
>
>