Hi All,
I hope I'm posting in the right section. I have a problem that I think is quite difficult, but maybe not. I was going to attach the spreadsheet I was working with.
Need to find if duplicate values exist in a Master sheet, compare in New generated sheet and then display the newly added datas in output sheet.
What I want to do, is search for duplicates by comparing master and new sheet by matching the columns datas. Once that is complete, it needs to delete the row of duplicate entries and update the new entries in output sheet.
I have attached the example file for the reference. Which the output should look like.
Bookmarks