How to find out the duplicates and highlight them?

[Learner7]

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.

[OTPM]

Hi Learner7
Follow this link for your solution:
http://www.lytebyte.com/2008/10/30/h...in-excel-2003/
Good luck
Tony(OTPM)

[Learner7]

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.

[Kimberly]

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

[Learner7]

Originally Posted by Kimberly

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.

[peterson07]

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.

[Pecoflyer]

After six years, I doubt the OP is sitll searching for an answer...