Re: calculating in a changing range

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:gkaste.1tawii_1123261515.8444@xxxxxxxxxxxxxxxxxxxxxxxx
>
> 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?action=getinfo&userid=24525
> View this thread: http://www.excelforum.com/showthread.php?threadid=392715
>


.

Relevant Pages

  • Re: calculating in a changing range
    ... I do, however, have one more situation that this dosent test for, that ... 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 ...
    (microsoft.public.excel.misc)
  • Re: Pass an array to Rank
    ... It's the first cell that you enter the formula in. ... >> Biff wrote: ... >>> easily but it takes 2 helper columns. ... >>> grass ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Min Function Excluding Zero Values & More
    ... Biff ... > Instead of returning 0 and having to use a formula that excludes it, ... >> 1) Find the MINexcluding zero values. ... >> non-zero value, this means that row 6 is now fully populated and should ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Name & Number in one cell.
    ... Biff, I have tried and I get an error message that states the formula ... a plain zero, ... In cell d1 I would like to show the name only (from cell a1 or ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Calculating dynamic range on signed data?
    ... you can't take the log of zero, ... I have thought about recording on a digital recorder with the ... input shorted and considering that the low end of the dynamic range. ... and RMS for recorded data as 16 and 24 bit WAV files. ...
    (comp.dsp)