match identical cols
 

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

match identical cols
 

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

match identical cols
 

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