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
268 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
Technology Partners: 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 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

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!

Question has a verified solution.

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

Suggested Solutions

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…
My experience with Windows 10 over a one year period and suggestions for smooth operation
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

726 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