Col1 Col2 Col3 Col4
apple red 4 dog
apple yellow 7 cat
banana purple 4 dog
banana blue 3 dog
banana green 8 cat
orange yellow 4 lion
orange purple 1 cat

Hello. Here I want to delete duplicates based on two columns, 'Column1' and 'Column2'
We have two apples, I want to use column2 to determine which row to delete. Between red & yellow, I want to delete yellow so row 2 will be deleted.

3 bananas. between purple, blue, and green I want to keep 'green' so row 3 and 4 will be deleted.

2 oranges. Between yellow and purple, I want to keep yellow over purple.

so here's the condition when deleting duplicates
red > yellow > green > purple > blue

I need VBA script to run this.. as soon as possible. Please help. Thank you!