View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GB3 GB3 is offline
external usenet poster
 
Posts: 4
Default Alternate row comparison

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.