Hello there!
Running a science project and I've stumbled across some huge issues with duplicate rows.
The issue as follows:
I've got a dataset with around 3000 rows with different duplicate ID:s.
The first row for every set of duplicates is the first event based on column O "Event_date".
Based on the column H "Side" i'd like to delete forthcoming rows with the same ID
that does not match the side of the first event row.
I've attached an excel file with the issue and given some more examples of my problem.
Sorry about my lack of skills in trying to explain my problem and also in excel...
Thank you for the help!
Bookmarks