Find duplicate rows

Script that can check column A and column B with Column D and E

I want help to find duplicates as in the attachment the A & B should be identical matches with D & E

If found then need to color both sides

The URL's of words can be 300 to 500 characters in many cases so identical should be found

Need to deal with start and end spaces and the last / slash

Need to ignore the start and end space and slash so we dont loose finding duplicates in such cases

Thanks in advance
Who is Participating?
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
Select the range A2:B1000 or whatever and apply the conditional format formula


Similarly for C2:D1000

mtthompsonsAuthor Commented:
Thanks does work but a little confused
1. Does it have a A & B as a pair and check D & E or its A vs D and B Vs E

2. If a match not found its 0 else its 1 can we have "Not found" as another option where link itself is not found
A and D has to get be checked and if exact URL not found then mention "Not found"
Saqib Husain, SyedEngineerCommented:
1. It is checking column A with D and column B with E and then combining the results of the two columns.

2. Use this formula (not tested)

=if(SUMPRODUCT(($A2=$D:$D)*($B2=$E:$E))=0,"Not found",SUMPRODUCT(($A2=$D:$D)*($B2=$E:$E)))
Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Saqib Husain, SyedEngineerCommented:
Sorry, For #2 where would you want the "Not found" displayed?
mtthompsonsAuthor Commented:
Not found in the cells if Column A is not found in D Or D not found in A
Saqib Husain, SyedEngineerCommented:
Sorry, not understood. In which cells? Can you show an example?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.