Sort/select by duplicates containing cell colour
I need COLUMN A to sort all duplicates to the top IF one of the duplicates contain a cell with a specific colour.*
Example:
234632498523
2523242237
8834523526
777777777777
24454784568
33333333333 CELL COLOR: YELLOW
573423452345
777777777777 CELL COLOR: YELLOW
33333333333
234573356
Wanted outcome:
777777777777 CELL COLOR: YELLOW
777777777777
33333333333 CELL COLOR: YELLOW
33333333333
353757353453
573423452345
3454756883453
57568567563
234573356
Or simply just selecting the duplicate pairs with cell colour as I need to move them to their own spreadsheet.
My issue is that I need to do this with 57.000 rows, so I would need this process to be automatic and apply to all duplicates with the specific cell color.
Any help guys? I have Kutools if this is any good.
Regards,
James
|