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

Attached Files

Test Sheet.xlsx (79.7 KB, 7 views)

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".

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

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks, this has been amended