Go Premium for a chance to win a PS4. Enter to Win

x
?
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
Medium Priority
?
274 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 31

Accepted Solution

by:
gowflow earned 2000 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 31

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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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 31

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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

916 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