I need help in regards to having an Events ID column (column A). Here I have multiple ID's some unique, some duplicates.
However, from this I want to delete any rows where BOTH Event ID and part number (column B) match. From the example from my below image and attached spreadsheet. Row 2 and 3 match in regards to the Event ID and part number, therefore, I want to have row 3 deleted and only keep the unique rows.
I also want to keep my other columns (C, D, E, F etc).
How can I do this? Do I use Conditional Formatting or do I use a formula?
Please note I hate approximately just over 50,000 rows! So I think a formula may crash this!