Sort/select by duplicates containing cell colour

[JamesTheNoob]

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

[JamesTheNoob]

The cells have been manually coloured.

To give a bit of background, I had a second column with information that had to match up, so I wanted to select all rows that contained that piece of information and then color the row to affect the COLUMN A that I am referring to. It's like selecting batches of apples that contain one red apple that has been placed there as an indicator.

COLUMN A has 5 rows of data that all link to one object.
COLUMN B has a 4 categories and language, ie. Russian or English

I need to select all the objects that have "Russian" in COLUMN B, so I need to select 5 rows in COLUMN A for each 1 row in COLUMN B that contains the word "Russian".

[Pecoflyer]

Please post a sample sheet so we can work on it. Thx (no pics or copy/paste)

[JamesTheNoob]

Originally Posted by Pecoflyer

Please post a sample sheet so we can work on it. Thx (no pics or copy/paste)

Thanks, this has been amended