Data removal and copy it to new location

uniformers

New member
Joined
Oct 12, 2015
Messages
1
Reaction score
0
Points
0
i have two excel sheets one have 1000 records in SHEET A one column and other have 100 records in SHEET B one column. i want to check these 100 records of SHEET B with 1000 records of SHEET A and out that if any record match it should be removed from 1000 records of SHEET A and copy it to third sheet or new book.
 
Unique or Duplicate - two column

Try
Code:
=IF(ISNA(MATCH(A2;B!$A$2:$A$101;0))=TRUE;"Unique";"Duplicate")
or
Conditional formatting
Code:
=IF(ISNA(MATCH(A2;B!A2:A101;0))=TRUE;TRUE;FALSE)
or
Code:
=ISNA(MATCH(A2;B!$A$2:$A$101;0))

Filter and copy data to Sheet 3
 

Attachments

  • uniformers-navic.xlsx
    30.1 KB · Views: 9
Back
Top