Matching identical datas of two coloumns

Closed
SAM - Jun 7, 2010 at 02:39 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Jun 7, 2010 at 05:47 AM
Hello,
i need to FIND THE MISMATCHING DATA comparing the datas in two coloumns OF SAME DATA...please help for this.....solution can be either formula or vba macro......



1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Jun 7, 2010 at 05:47 AM
let say the two columns are A and B then you can use


in C

=IF(ISERROR(MATCH(A1, B:B, 0)), 0, MATCH(A1, B:B, 0))
This gives you the row number of column B, where the value of cell A1 was matched. if no match was found, then it gives you zero

in D you can have
=IF(ISERROR(MATCH(B1, A:A, 0)), 0, MATCH(B1, A:A, 0))
Which will show row number of column A, where the value of cell B1 was matched, If no match was found, then 0

You would have to drag the formula to the last rows
0