I have a database with thousands of rows and want to remove duplicates but also keep records from earlier in certain conditions. Here is my problem:
Column A will have unique numbers for referals in other forumlas in my Sheet, call this ID of the row.
Column B is the one I want to search for duplicates in.
Column C has a "date"
Column D has a "state"
Column E has a "comment"
Column F has an "Internal state"
- If duplicate is found in Column B and "Date" and "State" hasnt changed the last row should be deleted.
- If "Date" and/or "State" has changed i will update the Column C and D in the first entry, then delete the duplicate row. In this case I also want to remove the "Internal State", but only if the "Internal state" has a spesific state, lets say abc.
Here is the script i have found, but dont know how to edit to get the result i want: