Remove Duplicates Based on other column Specific Value

Hi there,
I am new to this forum. Could you please help me with my issue to delete duplicate records based on other column specific Text? I have searched in so many ways but I couldn’t find a solution for my problem.

I have a macro found in this forum which is very useful to remove duplicates except first instance of Duplicates from Column “C”.
I need a macro which keeps one instance and remove other duplicates based on Other Column text value. In my case I need to keep either Cricket or Football from column “E” as a 1st instance and rest of all items should be deleted from Duplicates list. If none of the Duplicates have Cricket or Football in Column “E” needs to keep any value as 1st instance and remove the other duplicates.
Please find the attached excel spreadsheet having my current Macro which removes duplicates except 1st instance based on Column C.
1st tab having sampl data and second tab having the result what I am looking for.
I have arranged duplicates in a Sorting Order in Column C to understand easily. My actual project doesn’t have values in a sorting order.
Thanks in advance