How do i match identical data in col a and col b using col c

In column C1 use formula =EXACT(A1,B1) Fill down as needed if it is exactly
the same it will show True
If not the same it will show false.
Have a nice day mate.


"aquaflow" wrote in message
...
How do i match identical data in col a and col b using col c

Depends what you want. If you want to match identical data in the same row,
use EXACT as Skinman suggests. If you want to match data in different rows,
then it depends what you want in column C. Two suggestions:

1.
In C1 =IF(ISNA(MATCH(B1,$A$1:$A$10,0))=TRUE,"","Data matched")

This will enter "Data Matched in column C where the data in column B matches
a cell in column A.

2.
If you want to know where in column A the match is, then substitute "Data
matched" with MATCH(B1,$A$1:$A$10,0).
=IF(ISNA(MATCH(B1,$A$1:$A$10,0))=TRUE,"",MATCH(B1, $A$1:$A$10,0))

This will display the row WITHIN THE RANGE where the matched data lies. In
my example these will be the same, but if your range starts at A3, then the
match number will be 2 greater than the row number (eg a matched data in
sheet row 8 is row 6 in the specified range, so 6 will be displayed).

In each case, copy the formula down as far as you need.

--
Ian
--
"aquaflow" wrote in message
...
How do i match identical data in col a and col b using col c