LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sum of Alternate Cells Kamal Singh Oberh[_2_] Excel Discussion (Misc queries) 4 June 1st 08 07:46 PM
Help w/ alternate to Countif [email protected] Excel Worksheet Functions 3 December 3rd 07 06:43 PM
Alternate to Lookup? klm96 Excel Worksheet Functions 2 June 8th 05 12:29 PM
alternate blank row bayanbaru Excel Worksheet Functions 3 June 3rd 05 11:47 PM
Add alternate rows Teri Excel Worksheet Functions 6 March 16th 05 10:15 PM


All times are GMT +1. The time now is 06:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"