Cell Greater Than Cell in Adjacent Column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tom - 10 Jan 2008 18:25 GMT

    A    B    C    D
1    112.44    106.92    Y    is A1>B4
2    104.90    96.03    N    is A2>B4
3    109.71    103.46    N    is A3>B4
4    115.74    111.50    Y    is A4>B8
5    111.55    110.40    N    is A5>B8
6    112.85    112.56    N    is A6>B8
7    113.27    113.80    N    is A7>B8
8    118.58    114.59    Y    is A8>B9
9    118.25    115.85    Y    is A9>B12
10    99.75    115.83    N    is A10>B12
11    100.25    104.14    N    is A11>B12
12    103.69    101.00    Y    is A12>B13
13    103.58    99.84    Y    is A13>B14
14    107.99    100.75    Y    is A14>B15
15    106.33    104.27

I have two columns to which data is entered at the top by inserting a
blank row and then adding the data points. The formula that I would
like to create in row C would have to work from the bottom of the data
upwards and return the result as shown in column C. The process is
outlined in column D. Basically the formula determines if a(n)>b(n+1)
and if so then determines if a(n-1)>b(n). If not b(n) then becomes the
new reference point and the formula determines if a(n-2)>b(n).

Hope this is clear to everyone. Your help is much appreciated.

Thanks

Tom

Reply to this Message

Bernie Deitrick - 11 Jan 2008 02:01 GMT

Tom,

Sorry, it is NOT clear.

Your statement:

> Basically the formula determines if a(n)>b(n+1)
> and if so then determines if a(n-1)>b(n). If not b(n) then becomes the
> new reference point and the formula determines if a(n-2)>b(n).

But, on one row you seem to require the comparison A4>B8, which is not a
comparison that can be derived from the above statement.

You need to examine your logic and come up with a better explanation of what
you want. Your Y/N table appears to be based solely on a(n) > b(n+1)

HTH,
Bernie
MS Excel MVP

> A B C D
> 1 112.44 106.92 Y is A1>B4
[quoted text clipped - 26 lines]
>
> Tom

Reply to this Message

Tom - 11 Jan 2008 11:13 GMT

On Jan 10, 9:01 pm, "Bernie Deitrick" <deitbe @ consumer dot org>
wrote:

> Tom,
>
[quoted text clipped - 48 lines]
>
> - Show quoted text -

Sorry you are correct. To clarify what should be is the formula
determines if a(n)>b(n+1) and if so then determines
if a(n-1)>b(n). If not b(n) then becomes the new reference point and
the formula determines if a(n-2)>b(n). If not the the formula
determines if a(n-3)>b(n). If not then the formula determines if
a(n-4)>b(n) etc. If a(n-4)>b(n) then the cell in B adjacent to a(n-4)
becomes the new reference cell and the formula begins at the beginning
again a(n)>b(n+1). Hope this clarifies.

Thanks

Tom

Reply to this Message