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 sheet in consideration and not only the row that will be comapred.
The result needs to give me a "Match" answer, and if possible where the matched data is located in the second sheet.
Exp:
Sheet one
| A | B | C | Result |
| 100 | 200 | 300 | |
Sheet two
| A | B | C | Result |
| 100 | 200 | 300 |
I`m currently using a IF formula, but the arguement fails if the location of the row in either of the sheets is changed or not on the same position in both sheets.
Using excel 2016
Thanks in advance for the help.
Jody.
10 Replies
Please send your current (not fully working) formula mentioned here:
>> I`m currently using a IF formula, but the arguement fails if the location of the row in either of the sheets is changed or not on the same position in both sheets.
I like the the match formula suggestion, it sould work, maybe easy to adapt if I can see your current faulty version?maybe this info will help you further ...
Compare two versions of a workbook by using Spreadsheet Compare
Compare two or more worksheets at the same time
I would be happy to find out if I could help.
Nikolino
I know I don't know anything (Socrates)
Hiu NikolinoDE
Thank you very much for the information.
However I`m looking to the verification within one workbook.
Thank you
Ramiz_Assafthank you so much.
Will apply and give feedback
If it works fine, please mark as solved!
