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
265 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
This article will show you how to use shortcut menus in the Access run-time environment.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

863 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now