Delete duplicate rows where Event ID and part_number matches. Keep only unique records.

Hi,

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!

Please help

Capture10.PNG