You didn't try what I suggested. Do this *before* you=20
come back with more questions.

1. Paste the formula in row 1.
2. Now copy the cell and paste it in row 35 of the same=20
column.

The references will change to row 35. You should see this:

=3DIF(A35&C35=3DE35&F35,"A",IF(B35&D35=3DE35&F35," B","C"))

Jason

-----Original Message-----
sorry I may have misunderstood.

I have upto 700 rows which i want to compare and use the=20
formula above.
By leaving it as:
IF(A1&C1=3DE1&F1,"A",IF(B1&D1=3DE=AD1&F1,"B","C") )

Wouldn't each formula always check row 1? So I want to=20
put this
formula in each row at column G but if I put the above=20
in row 35 would
it check row 1 and give me that result?

So rather than manually change this upto 700 times to=20
reflect the row
it's in - can this be done some other way?

.