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" wrote in
message ...

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