So I have a list of names in a column on a spreadsheet. I also have an HTML file containing text with these names appearing in it sporadically.
How can I check the frequency of appearance of the names in Col A and print the number of times they appear in the HTML document in Col B?
What would even be the best strategy here? Is there software that can do this or something similar, or do I need a script of some sort?
My scripting knowledge is very limited so recommendation of Mac OS X compatible software that could accomplish this or pointers to published scripts would be best.