Compare two excel sheet

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,



i want to compare two excel sheets if the row in second sheet is not there in the first sheet i need to copy that row from second sheet to first sheet

please help me

sam

2 replies

i mean to say is i wnt to merge two excel sheet without duplications
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
and what makes a row unique ? are you saying for a row to be unique, each cell on the row is to be different ?

If that is the case, create a temp column in each sheet. and combine all cells on the row into one by formula (some like =A1 & "|" & b1 & "|" & c1

copy this column into a new sheet. append to same column from the other sheet
use filter, advance filter and obtain the unique values
use data text-to-column to split on "|"