- Registration date
- Thursday January 28, 2010
- Last seen
- August 2, 2020
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 "|"