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)

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

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.

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.

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.

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

__________________
Using O365 v2503 - 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