Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-29-2011, 02:11 AM
Learner7 Learner7 is offline How to find out the duplicates and highlight them? Windows XP How to find out the duplicates and highlight them? Office 2007
Advanced Beginner
How to find out the duplicates and highlight them?
 
Join Date: May 2010
Posts: 51
Learner7 is on a distinguished road
Default How to find out the duplicates and highlight them?

Hi,

I have a big task to find out all the duplicates and highlight them. There are over 3500 rows to be checked.

How can I find out all the duplicates rows and highlight them programitically. The sample sheet is attached.

Please do help.
Attached Files
File Type: xlsx Highlight Duplicates.xlsx (7.7 KB, 16 views)
Reply With Quote
  #2  
Old 06-29-2011, 06:32 AM
OTPM OTPM is offline How to find out the duplicates and highlight them? Windows 7 32bit How to find out the duplicates and highlight them? Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi Learner7
Follow this link for your solution:
http://www.lytebyte.com/2008/10/30/h...in-excel-2003/
Good luck
Tony(OTPM)
Reply With Quote
  #3  
Old 06-29-2011, 07:48 AM
Learner7 Learner7 is offline How to find out the duplicates and highlight them? Windows XP How to find out the duplicates and highlight them? Office 2007
Advanced Beginner
How to find out the duplicates and highlight them?
 
Join Date: May 2010
Posts: 51
Learner7 is on a distinguished road
Default

Thanks again for your kind help. Actually I forgot to write the condition there.

It should check first 3 cells data in each row to compare it. Suppose, if Row 1 data in Cell A, Cell B & Cell C match with Row 2 data Cell A, Cell B & Cell C then it should highligh it. In some case more than 4 rows may have the same data as well.

Waiting for your kind help.

Best regards.
Reply With Quote
  #4  
Old 06-29-2011, 08:35 AM
Kimberly Kimberly is offline How to find out the duplicates and highlight them? Windows 7 64bit How to find out the duplicates and highlight them? Office 2010 64bit
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

  1. In a new column, concatenate the first 3 columns. (e.g.: =A1&B1&C1 and copy down)
  2. Select this new range
  3. On the Home tab, click Conditional Formatting > Highlight Cell Rules > Duplicate Values
Reply With Quote
  #5  
Old 06-29-2011, 10:14 PM
Learner7 Learner7 is offline How to find out the duplicates and highlight them? Windows XP How to find out the duplicates and highlight them? Office 2007
Advanced Beginner
How to find out the duplicates and highlight them?
 
Join Date: May 2010
Posts: 51
Learner7 is on a distinguished road
Default

Quote:
Originally Posted by Kimberly View Post
  1. In a new column, concatenate the first 3 columns. (e.g.: =A1&B1&C1 and copy down)
  2. Select this new range
  3. On the Home tab, click Conditional Formatting > Highlight Cell Rules > Duplicate Values
Thanks for your kind help. It wokrs for me.

Regards.
Reply With Quote
  #6  
Old 06-08-2017, 02:40 AM
peterson07 peterson07 is offline How to find out the duplicates and highlight them? Windows 8 How to find out the duplicates and highlight them? Office 2007
Novice
 
Join Date: Jun 2017
Posts: 1
peterson07 is on a distinguished road
Default

Why don't you try Duplicate Files Deleter? It will do a thorough search of your hard disk and find out the two or more duplicate files of the same file which may be stored at different locations. It will give you a comprehensive list of all those files and you can decide for yourself what you want to do with them. It's easy to use. Hope it will help you.
Reply With Quote
  #7  
Old 06-08-2017, 06:04 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How to find out the duplicates and highlight them? Windows 7 64bit How to find out the duplicates and highlight them? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

After six years, I doubt the OP is sitll searching for an answer...
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to find out the duplicates and highlight them? Find and highlight multiple words in MS Word document AtaLoss Word VBA 37 09-22-2021 12:04 PM
Highlight text and find next instance DrDOS Word 0 11-15-2010 04:02 PM
Find duplicates formula hannu Excel 2 10-26-2010 02:48 AM
find - reading highlight - highlight all / highlight doesn't stick when saved bobk544 Word 3 04-15-2009 03:31 PM
How to find out the duplicates and highlight them? sum of duplicates zxmax Excel 1 09-29-2006 08:29 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:54 PM.


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