I need an Excel macro that will parse data from separate Excel files and build a dictionary of unique words and phrases and a count of each word used.
Additionally, I need the separate ability to:
1) specify a particular phrase (e.g, 'your moma') to be searched for in the data, create a list of users who have used that phrase, as well as the total number of uses of the phrase; and
2) record the searched-for phrase, and record the number of times used in a month/year.
It is expected that a number of different Excel files will be processed sequentially.
See attached document for specific requirements.
Sample input Excel data file added. Column A = Author; Column E = Text, and F = Date. Search Phrase = 'in the'. Expect to find nine instances.
32 freelancers are bidding on average $144 for this job
Hello. I am Witoon, Excel VBA Expert. I am familiar with this kind of job. Open file, look up, data manipulation and automatic report maker. Please feel free to message me if you interest. Thank you very much.
I am putting my best knowledge and efficiency in to every works. I have done my all jobs with an administrative professionalism and versatile office skills.I am confident that I would be a valuable asset to you.
Hii sir I am experience person I have six year experience as financial accounting & data management data analysis work I provide you best quality & services Thankyou