Home

Find Duplicates Outside of Selection/Highlight in the Same Column - Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-414936%22%20slang%3D%22en-US%22%3EFind%20Duplicates%20Outside%20of%20Selection%2FHighlight%20in%20the%20Same%20Column%20-%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-414936%22%20slang%3D%22en-US%22%3E%3CDIV%3EHey%20guys%2C%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EI%20want%20to%20sort%20a%20column%2C%26nbsp%3B%3C%2FDIV%3E%3CDIV%3Ethen%20select%20a%20section%20of%20that%20column%2C%26nbsp%3B%3C%2FDIV%3E%3CDIV%3Eand%20then%20unsort%20the%20column%26nbsp%3B%3C%2FDIV%3E%3CDIV%3Eand%20let%20Excel%20find%20me%20all%20duplicates%20throughout%20that%20column%20that%20corresponds%20to%20any%20of%20the%20cells%20I%20selected%20before%20and%20preferably%20select%20them.%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EIn%20short%3B%20I%20need%20Excel%20to%20find%20me%20any%20duplicates%20of%20any%20cell%20inside%20my%20selection%2C%20but%20OUTSIDE%20of%20my%20selection%20in%20the%20same%20column.%3C%2FDIV%3E%3CDIV%3E%3CBR%20%2F%3EExample%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3E%3CSPAN%3E(34%20SELECTED)%3C%2FSPAN%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CSPAN%3E(73%20SELECTED)%3C%2FSPAN%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E23%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E86%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E234%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E21%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E73%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E853%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E34%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E11%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CBR%20%2F%3E%3CBR%20%2F%3EOUTCOME%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FDIV%3E%3CDIV%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3E%3CSPAN%3E(34%20SELECTED)%3C%2FSPAN%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CSPAN%3E(73%20SELECTED)%3C%2FSPAN%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E23%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E86%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E234%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E21%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CSPAN%3E(73%20SELECTED)%3C%2FSPAN%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E853%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CSPAN%3E(34%20SELECTED)%3C%2FSPAN%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E11%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FDIV%3E%3CDIV%3EAny%20help%3F%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EThanks!%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-414936%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
JamesStewartExcel
Occasional Contributor
Hey guys,
 
I want to sort a column, 
then select a section of that column, 
and then unsort the column 
and let Excel find me all duplicates throughout that column that corresponds to any of the cells I selected before and preferably select them.
 
In short; I need Excel to find me any duplicates of any cell inside my selection, but OUTSIDE of my selection in the same column.

Example:

(34 SELECTED)
(73 SELECTED)
23
86
234
21
73
853
34
11


OUTCOME:



(34 SELECTED)
(73 SELECTED)
23
86
234
21
(73 SELECTED)
853
(34 SELECTED)
11
Any help?
 
Thanks!