Prev: Literal based on Week end
Next: Calculating Elapsed Time Over a Set Period
From: GB3 on 26 Dec 2009 12:49
Thanks to all. Now my problem is overcoming rigidity of thinking. I had
some monstrosity of nested IFs and Row() functions -- none of which worked --
and resulted in my growing that creature with layers of twisted logic.

Don, you've got me thinking about macros now anyway. Thanks again.
Rick, and thank you too -- your solution is simple. I just didn't believe
Excel would be able to reapply the 2-row logic with only 2 rows as an example.
But I didn't check either.

Rick Rothstein wrote:
>He's comparing pairs of rows, not individual rows. Rows 1 and 2 are being
>compared, as a pair, separately from Rows 3 and 4, which are compared as
>their own pair... Rows 2 and 3 are not linked in any way as they belong to
>separate pairings.
>
>> >Score 1 2 1 3 0 6 greater
>>>Score 2 0 0 0 0 0
>[quoted text clipped - 36 lines]
>>>
>>> Thanks very much.

From: Arvi Laanemets on 27 Dec 2009 05:42
Hi

Start your data from row 2 (you can have column headers in 1st row). Then
the formula will be:
=IF(IF(ISODD(ROW()),F2>F1,F2>F3),"greater","")


Arvi Laanemets


"GB3" <u57077(a)uwe> wrote in message news:a12bd3252ed3e(a)uwe...
> I've seen a few similar problems, but not quite what I'm seeking help for
> here.
> My goal is to write a formula to compare 2 rows of summed values for a
> lengthy spreadsheet - comparing the values of even-row scores and odd-row
> scores -- (Col G) here.
> So 5 is > 3 for rows 1&2; 4 is > 3 for rows 3&4, etc.
>
> Here's an example:
>
> Score 1 3 0 0 0 3
> Score 2 0 3 1 1 5 greater
> Score 1 1 2 0 0 3
> Score 2 0 0 2 2 4 greater
> Score 1 0 2 3 1 6 greater
> Score 2 1 0 0 4 5
> Score 1 2 1 3 0 6 greater
> Score 2 0 0 0 0 0
> Score 1 1 0 0 1 2
> Score 2 0 1 2 0 3 greater
>
> I have used the MOD function to identify whether the row is even or odd,
> but
> I can't determine how to write the expression that in essence would say,
> that
> if the value of the Col G entry in row 3 is > than the value of the entry
> in
> Col G in row 4, then write "greater" in row 3, Col H.
>
> In a related vein, is it possible to subscript in Excel formulas? --
> e.g., G
> [Row()] so as to refer to G3 when the formula is in Row 3?
>
> Thanks very much.
>


First  |  Prev  | 
Pages: 1 2 3
Prev: Literal based on Week end
Next: Calculating Elapsed Time Over a Set Period