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...
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?
