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...
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")Hi SergeiBaklan
Thank you very much, will try and revert.