Forum Discussion
Help counting duplicate values/words
Amber, you may use Microsoft Word, whatever, if you are only able to save your text as .txt file. Since you don't need formatting for frequency analysis that shall not be an issue. With Word that's simple, you always may do Save As into txt.
From Power Query solution point of view that's easy, just couple more lines in the script. I'll update in a while.
Hi Amber,
Perhaps in your case is better to use available frequency analysis tools, for example this free one http://countwordsfree.com/. You just paste your text into the web from and receive back a lot of statistic, includes frequency analysis.
However, I updated the Excel solution as well, see attached file. To use it you shall put full path to your txt file in B2, minimum length of words to count in next down cell and into the right table words which you would like to exclude from statistics. Don't forget to Refresh All after any change:
I won't explain the script here, it was slightly modified compare to previous post.
Thank you so much Sergei! This was perfect and did the job. I have to figure out how to exclude certain words but at least I have the numerical information. You are the best!
Hi Amber,
I'm not sure if you use 'second' version, it's with option to exclude some words, plus small mistake with punctuation was corrected. We are still not able to download attached files on this site. You may download it from here https://1drv.ms/x/s!AtxUiuh14KBaqPgBY_iRv93IhDZ_tQ
And i didn't check Wyn's solution, perhaps it has this option as well.
Hi Sergei, I couldn't see a file attached
I've had a go at a solution in the attached file here
Amber,
Enter / Paste lines of text in the blue table, then Right-Click refresh the green table (it does require you to have Excel 2016, or download the Power Query addin)
Wyn, TechComm changed the interface over weekend, I'm as well have no idea how to download attachments now.
