Solved

Find identical Url's in column "F" and if identical URL's in column "H" then color the row

Posted on 2013-01-10
6
269 Views
Last Modified: 2013-01-10
Find identical Url's in column "F" and if identical URL's in column "H" then color the row
Attached excel
Find-identicals.xls
0
Comment
Question by:bsharath
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 30

Accepted Solution

by:
gowflow earned 500 total points
ID: 38762132
Hi
Is this what your looking for ? Make sure your macroes are activated and run the button Color Duplicates and check the results.
gowflow
Copy-of-Find-identicals.xls
0
 
LVL 11

Author Comment

by:bsharath
ID: 38762147
Perfect

In a case where URL is like this

http://mail.google.com/support/bin/answer.py?hl=en&answer=10708&topic=13301

http://mail.google.com/support/bin/answer.py?hl=en&answer=118708&from=6560&rd=1

http://mail.google.com/support/bin/answer.py?hl=en&answer=10708&topic=13301

1st and last are same but it did not color even though the URL's in "F" are same

Does it check column "H" only the ones thats next to it?
0
 
LVL 30

Expert Comment

by:gowflow
ID: 38762159
yes it is checking ColF & ColH when both are the same it colors. Is that what you want ?
gowflow
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 11

Author Comment

by:bsharath
ID: 38762169
Yes it does right now but

if Row 1"F": and Row 100 "F" is same and "H" is same in both cases does it color?

or does the script check for the adjacent ones only?
0
 
LVL 30

Expert Comment

by:gowflow
ID: 38762175
well !!! this is why I sort the workbook first to have them following each others. You need to tell me the sort order I sort by Col F then Col B it seems your sorting is diffrent as you have Row 1 then row 100 They need to follow. What is the best sorting ?

Mind you if there is not a better way of sorting then I can change the code accordingly.
gowflow
0
 
LVL 11

Author Comment

by:bsharath
ID: 38762184
0

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question