alanaduffy
New Member
- Joined
- Sep 25, 2019
- Messages
- 2
Hi there!
My dataset represents work projects and contains columns such as Name, Position, Start Date, and End Date. The columns extend from A to AO, where AO is the end-date.
The data is updated weekly, and contains almost entirely exact duplicates. However, where last week's data may have had a project with no end date (represented by "-"), this week's data could contain the same project twice; once with last week's data containing "-", and once with an updated, actual end-date. The guy who sends me data just adds new information without removing anything it overlaps with.
I need a code that compares all rows to each other based on columns A-AP, then if a duplicate is found, it looks at column AO. If it finds that one row has "-" in column AO, and the other row has a date, it selectively deletes the row with "-"
Thank you for any help!
My dataset represents work projects and contains columns such as Name, Position, Start Date, and End Date. The columns extend from A to AO, where AO is the end-date.
The data is updated weekly, and contains almost entirely exact duplicates. However, where last week's data may have had a project with no end date (represented by "-"), this week's data could contain the same project twice; once with last week's data containing "-", and once with an updated, actual end-date. The guy who sends me data just adds new information without removing anything it overlaps with.
I need a code that compares all rows to each other based on columns A-AP, then if a duplicate is found, it looks at column AO. If it finds that one row has "-" in column AO, and the other row has a date, it selectively deletes the row with "-"
Thank you for any help!
