Hi,

You could use conditional formatting.
Let's suppose that the data are in A2:A1001 and B2:B1001.
Select the entire data (i.e., A2:B1001) -- "Format" -- "Conditional
Formatting" -- in the drop down box under Condition 1, select "Formula Is"
-- in the formula bar enter =$A2=$B2 -- Click on "Format" button select
"Patterns" and select a color -- "OK" -- "OK".
This will color the cell pairs containing matching data.

OR

In column C2 enter the formula, =IF(A2=B2,"X",""), and fill-in the formula
down to the last row. The formula will return an "X" symbol wherever there
is a match between columns A and B.

Hope this helps,
Regards,
B. R. Ramachandran



"gallie" wrote:

There are two columns of data in one spreadsheet. Each column is governned by
a different equation, and I want to know how to find any pair of matching
answers between the columns.