To Match Column A and Colum b and delete the value.

[erickhk83]

Helo everyone,

Could some 1 help me advise on this. i have about 8000 data to run trough and i need to eliminate those that match and only those that didnt match remains from colum A and Column B

Sample :

If data in row A match any value in Row b remove this entries for repeated values.

[Jack40]

hi,

Just sort by both colum seperatly. ( first colum A then column B).


Then enter the formula =B1=A1 in column C. then delete by True.


Is this helps??

Regards

Jack