S

#### soilcon1

A is the same as column C on a spreadsheet. If it is not, I am inserting

cells above all the data in column C until I find a match with column A.

What is happening is that the EXACT function seems to stay fixed with it's

original cell in column C. Example:

A1=apple, C1=orange, B1=EXACT(A1,C1) results in FALSE

But, A2=orange and C1=orange, so I insert a cell above the cell in C so that

it becomes C2. So now:

A2=orange and C2=orange. But the EXACT function in column B in row 2 now

says:

B2=EXACT(A2,C3). C3=banna, so the result if False.

I want the function to remain B2=EXACT(A2,C2), NOT change to C3.

When more data is entered into the rows A and C later, I need to be able to

fill the EXACT formula down, so I don't think I can use $. I don't want to

enter the function individually into each cell in column B.

Any ideas?