Forum Discussion
Data compare
Good day community. I need assistance please. Is there a formula that i can use to compare two sheets for dupplicate data rows. The compare formula needs to take all the data of the second shee...
Ramiz_Assafthank you so much.
Will apply and give feedback
If it works fine, please mark as solved!
Hi Ramizassaf.
No my problem has not been solved.
The formulas (X-lookup and CONCAT) used in your spreadsheet is not available in my version of Excel, currently using Excel 2016.
Thank you
As variant, for such sample
is
=IFNA(MATCH(A1&B1&C1,Sheet2!$A$1:$A$1000&Sheet2!$B$1:$B$1000&Sheet2!$C$1:$C$1000,0),"nu duplication")
