Hello,
I am looking for a help to find the duplicate then records i.e. Repeating of Service code & Service Description.
Here is the explanation.
1. Script should check within the same sheet i.e. Old List or New List whether the service code is repeating without matching Service Description & price.
2. Script should check within the same sheet i.e. Old List or New List whether the Service Description is repeating without matching Service Code & Price.
If the above mentioned fields are repeating then then complete row should copy to third sheet i.e. Duplicate with following additional information for track the record.
1. The script should write the prices of the records based on how many times the record is repeating. Example: If the record is repeating 3 times with 3 different price. It should write all the three prices i.e. 50, 40 & 100
2. The script should tell me how many time the service code & service description is repeating within the same sheet i.e. Old List Or New List.
3. The script should tell me what is repeating i.e. Service Code or Service Description.
4. The script should tell me the sheet name and the row number. Sheet name should be one time but the row no. will be multiple based on repeating times.
I hope this will clarify what I want.
Please see the attached sample file for more clarification.
Bookmarks