![]() |
#1
|
|||
|
|||
![]()
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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Place on value in a cell from that time, after 4 hours colour of the cell should change | vvenka100 | Excel | 1 | 04-26-2018 01:13 PM |
![]() |
thymas | Excel | 2 | 08-01-2016 11:50 PM |
![]() |
bertietheblue | Word | 2 | 04-15-2016 12:30 PM |
![]() |
jaywizz1 | Excel | 1 | 03-11-2016 05:09 PM |
Quickly select lines of certain colour | RFoudy | PowerPoint | 27 | 09-09-2014 12:35 AM |