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
267 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
  • 3
  • 3
6 Comments
 
LVL 29

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 29

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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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 29

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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…
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

839 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