I have a list of about 4000+ websites that I need to filter and count. The problem is with the website names... I want to count all the instances of espn.com but the URLs are all different ie. espn.com/nfl espn.com/nba chicago.craigslist.com newyork.craigslist.com. etc
Is there any simple way to sort through this stuff without doing it manually?
Thanks
Hi - Assuming your data of websites is in column A, use something like this in B1:
Formula:
=COUNTIF(A:A,"*"&"espn.com"&"*")
Hope this helps.
If solved kindly remember to mark Thread as solved.
Click the small star icon at the bottom left of my post if this was useful.
That still requires me to go through all 4000+ sites and pick out each individual site (and there will be a few hundred unique ones in there).
Are you able to upload workbook with the list of websites.
Thread can be locked. Going a different route.
Thanks
as you wish
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks