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

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-09-2019, 01:40 AM
JamesTheNoob JamesTheNoob is offline Find Duplicates Outside of Selection/Highlight in the Same Column - Excel Windows 10 Find Duplicates Outside of Selection/Highlight in the Same Column - Excel Office 2016
Novice
Find Duplicates Outside of Selection/Highlight in the Same Column - Excel
 
Join Date: Apr 2019
Posts: 5
JamesTheNoob is on a distinguished road
Default Find Duplicates Outside of Selection/Highlight in the Same Column - Excel

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!
Reply With Quote
  #2  
Old 04-10-2019, 02:01 PM
p45cal p45cal is offline Find Duplicates Outside of Selection/Highlight in the Same Column - Excel Windows 10 Find Duplicates Outside of Selection/Highlight in the Same Column - Excel Office 2016
Expert
 
Join Date: Apr 2014
Posts: 268
p45cal has a spectacular aura aboutp45cal has a spectacular aura aboutp45cal has a spectacular aura about
Default

Surely you can use Autofilter for this (no sorting/unsorting required); it will give you a dropdown with a sorted-and -distinct list to choose from (with selection boxes), you filter on those values. Then you can select all the filtered results, then press F5 on the keyboard, Special Cells…, Visible cells only, then clear the Autofilter using the dropdown in that column's header.
Reply With Quote
Reply

Tags
duplicates, sorting

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel - to compare few column and find the different norasiken Excel 3 08-28-2017 10:36 PM
How to find out the duplicates and highlight them? Learner7 Excel 6 06-08-2017 06:04 AM
Excel 2013 Alt F doesn't block selection in find anymore KatMagic Excel 0 03-15-2014 12:44 PM
Find Duplicates Outside of Selection/Highlight in the Same Column - Excel Need help on duplicates in column; deciding which to keep based on other column nwcf Excel 3 01-31-2014 09:43 AM
find - reading highlight - highlight all / highlight doesn't stick when saved bobk544 Word 3 04-15-2009 03:31 PM


All times are GMT -7. The time now is 09:28 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft