Home

Sort/select by duplicates containing cell colour

%3CLINGO-SUB%20id%3D%22lingo-sub-407380%22%20slang%3D%22en-US%22%3ESort%2Fselect%20by%20duplicates%20containing%20cell%20colour%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-407380%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20need%20COLUMN%20A%20to%20sort%20all%20duplicates%20to%20the%20top%20IF%20one%20of%20the%20duplicates%20contain%20a%20cell%20with%20a%20specific%20colour.%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EExample%3A%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3E234632498523%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2523242237%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E8834523526%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E777777777777%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E24454784568%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E33333333333%20CELL%20COLOR%3A%20YELLOW%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E573423452345%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E777777777777%20CELL%20COLOR%3A%20YELLOW%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E33333333333%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E234573356%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EWanted%20outcome%3A%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3E777777777777%20CELL%20COLOR%3A%20YELLOW%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E777777777777%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E33333333333%20CELL%20COLOR%3A%20YELLOW%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E33333333333%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E353757353453%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E573423452345%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E3454756883453%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E57568567563%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E234573356%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%3CSPAN%3EOr%20simply%20just%20selecting%20the%20duplicate%20pairs%20with%20cell%20colour%20as%20I%20need%20to%20move%20them%20to%20their%20own%20spreadsheet.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EMy%20issue%20is%20that%20I%20need%20to%20do%20this%20with%2057.000%20rows%2C%20so%20I%20would%20need%20this%20process%20to%20be%20automatic%20and%20apply%20to%20all%20duplicates%20with%20the%20specific%20cell%20color.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EAny%20help%20guys%3F%20I%20have%20Kutools%20if%20this%20is%20any%20good.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3ERegards%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EJames%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-407380%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-407724%22%20slang%3D%22en-US%22%3ERe%3A%20Sort%2Fselect%20by%20duplicates%20containing%20cell%20colour%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-407724%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20cells%20have%20been%20manually%20coloured.%3C%2FP%3E%3CP%3ETo%20give%20a%20bit%20of%20background%2C%20I%20had%20a%20second%20column%20with%20information%20that%20had%20to%20match%20up%2C%20so%20I%20wanted%20to%20select%20all%20rows%20that%20contained%20that%20piece%20of%20information%20and%20then%20color%20the%20row%20to%20affect%20the%20COLUMN%20A%20that%20I%20am%20referring%20to.%20It's%20like%20selecting%20batches%20of%20apples%20that%20contain%20one%20red%20apple%20that%20has%20been%20placed%20there%20as%20an%20indicator.%3CBR%20%2F%3E%3CBR%20%2F%3ECOLUMN%20A%20has%205%20rows%20of%20data%20that%20all%20link%20to%20one%20object.%3CBR%20%2F%3ECOLUMN%20B%20has%20a%204%20categories%20and%20language%2C%20ie.%20Russian%20or%20English%3C%2FP%3E%3CP%3EI%20need%20to%20select%20all%20the%20objects%20that%20have%20%22Russian%22%20in%20COLUMN%20B%2C%20so%20I%20need%20to%20select%205%20rows%20in%20COLUMN%20A%20for%20each%201%20row%20in%20COLUMN%20B%20that%20contains%20the%20word%20%22Russian%22.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F314823%22%20target%3D%22_blank%22%3E%40JamesStewartExcel%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
JamesStewartExcel
Occasional Contributor

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

1 Reply

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

@JamesStewartExcel 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
17 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies