Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 04-09-2019, 01:40 AM
JamesTheNoob JamesTheNoob is offline Windows 10 Office 2016
Novice
 
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 online now Windows 10 Office 2016
Competent Performer
 
Join Date: Apr 2014
Posts: 238
p45cal will become famous soon enough
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
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 08:49 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft