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!