Remove Duplicates - base on two columns Complicated
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!
Recent comments
5 years 34 weeks ago
6 years 20 weeks ago
6 years 32 weeks ago
6 years 35 weeks ago
6 years 36 weeks ago
6 years 42 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago