I have company names in Column A.
I want to determine the most popular 2-word phrases.
Home Remodeling Services
Residential Remodeling Services & Solutions
Matt's Remodeling Services, LLC
In the example above, the most popular 2-word phrases is "Remodeling services"
I need the formula or script to look at the entire Column A (as it may have different amounts of records). The output can be to the side or on another sheet.
You MUST indicate that you have read the posting to be considered.
I would like to get this done ASAP. If you can do it now, let me know how long it will take to complete as that will factor into my decision which I will make within 10-20 minutes of posting.
The macro should show a list of the most frequent two-word phrases with the count to the right of it.
It can show the top 100 or 1000 or unlimited. Just as long as I can sort to determine which phrases are the most popular.
Can do it within 1 hr of you providing the data. Can also provide a dynamic number of words (e.g. 2 in this case), for an additional price. Thanks, Anurag