Find Duplicate Rows Where Two Columns Match

Hi There,

I'm trying to find and highlight duplicate rows of data where two columns contain the same information. My scenario is (Column1: Name) (Column2: Address). From these two columns I want to be able to run some code that will highlight all the rows where the 'Name' and 'Address' in one row match to another.
So for example if I had the followign data:
Row1: Joe Bloggs, The House
Row2: Joe Bloggs, Flat 1
Row3: Joe Bloggs, The House

I would like it to highlight Row 1 and Row 3 please as both column 1 and 2 are a matching pair as opposed to Row 2 where only the name is the same. Currently I have the following code but it doesn't highlight just the matching pairs it would highlight in my previous example Row2 as well as the name matches that of Row1 and 3.

Please Login or Register  to view this content.

I would really appreciate some help on this please as my knowledge of excel is limited.

Many thanks,

Dom

Hi Dom

Give this a try....

Please Login or Register  to view this content.

Hi Dom

I cannot recreate as I do not have a sample of your workbook to test....
I think it might be that you did not change the Field no's ....

Please Login or Register  to view this content.

i.e. A is field 1 so D should become Field 4 and E Field 5
Yes, we can add a loop to go through all the sheets...

To attach a file, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

...No duplicates in the individual sheets.....

Please Login or Register  to view this content.

In future, please please request the exact requirement from start as this will ensure that no time gets wasted on code that does not match the request.

Nice one jindon

Nope edit not working....I thik OP wants all duplicates on sheets to be highlighted...

Originally Posted by MCCDOM

I'm trying to find and highlight duplicate rows of data where two columns contain the same information. My scenario is (Column1: Name) (Column2: Address). From these two columns I want to be able to run some code that will highlight all the rows where the 'Name' and 'Address' in one row match to

Try

Please Login or Register  to view this content.

OOPs,a typo

Please Login or Register  to view this content.

A bit unorthodox I guess....Think it does what is required....

Please Login or Register  to view this content.

Glad I could contribute...tx for rep.