Kumar Salui
New Member
Hello All,
I am trying to remove the duplicate entries from "Masterdata" tab and copy them to "Duplicatedata" tab of the attached excel file. Let me explain the problem in detail:
I have a 10000+ line items of customer data, where the customers are serviced by multiple partners, some of them are serviced by a single partner. However, I found that the data was entered in such a way that some of the partner data became duplicates for the same customer.
Please refer to the attached excel:
e.g. Row#2 & row#3, the customer is serviced by one partner, but there is a duplicate entry; the same happens for Row #4 & #5.
For Row#6-8, the customer is serviced by two different partners, but for one partner, there is a duplicate entry.
For Row#9-11, customer serviced by one partner, but it is entered 3 times.
The expected outcome:
For row #2-3 - Row# 2 should remain in "Masterdata", row # 3 should be removed from "Masterdata" tab and copy to "Duplicatedata";
For Row#4, #5 - Row# 4 should remain in "Masterdata", row # 5 should be removed from "Masterdata" tab and copy to "Duplicatedata";
For Row#6-8 - Row# 6 & 7 should remain in "Masterdata" (non-duplicate rows), row # 8 should be removed from "Masterdata" tab and copy to "Duplicatedata"; same for
For row#9-11 - Row# 9 should remain in "Masterdata", row # 10-11 should be removed from "Masterdata" tab and copy to "Duplicatedata";
Just to mention, I found some of the data were duplicated many times (as high as 6 times).
Thank you all in advance.
Kind regards,
Kumar
I am trying to remove the duplicate entries from "Masterdata" tab and copy them to "Duplicatedata" tab of the attached excel file. Let me explain the problem in detail:
I have a 10000+ line items of customer data, where the customers are serviced by multiple partners, some of them are serviced by a single partner. However, I found that the data was entered in such a way that some of the partner data became duplicates for the same customer.
Please refer to the attached excel:
e.g. Row#2 & row#3, the customer is serviced by one partner, but there is a duplicate entry; the same happens for Row #4 & #5.
For Row#6-8, the customer is serviced by two different partners, but for one partner, there is a duplicate entry.
For Row#9-11, customer serviced by one partner, but it is entered 3 times.
The expected outcome:
For row #2-3 - Row# 2 should remain in "Masterdata", row # 3 should be removed from "Masterdata" tab and copy to "Duplicatedata";
For Row#4, #5 - Row# 4 should remain in "Masterdata", row # 5 should be removed from "Masterdata" tab and copy to "Duplicatedata";
For Row#6-8 - Row# 6 & 7 should remain in "Masterdata" (non-duplicate rows), row # 8 should be removed from "Masterdata" tab and copy to "Duplicatedata"; same for
For row#9-11 - Row# 9 should remain in "Masterdata", row # 10-11 should be removed from "Masterdata" tab and copy to "Duplicatedata";
Just to mention, I found some of the data were duplicated many times (as high as 6 times).
Thank you all in advance.
Kind regards,
Kumar