Cell Greater Than Cell in Adjacent Column

[Tom]

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

 

[Bernie Deitrick]

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

 

[Tom]

Tom,

Sorry, it is NOT clear.

Your statement:


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








- 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