How to find out the duplicates and highlight them?

		Microsoft Office Forums > Microsoft Excel > Excel
How to find out the duplicates and highlight them?

FAQ

Thread Tools

Display Modes

06-29-2011, 02:11 AM

Learner7

Windows XP How to find out the duplicates and highlight them?

Office 2007

Advanced Beginner

Join Date: May 2010

Posts: 51

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

Highlight Duplicates.xlsx (7.7 KB, 18 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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
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 04:24 PM.