I have changed how I want to go about doing this. Progress indicator is no longer required. See this post.
Hi there,
I am wanting to count and create a tag cloud for unique keywords on a data set that has 20,000 complaints on seperate rows by using something like a word frequency count macro (pivot table is not necessary) and chandoos tag cloud script with the following modifcations:
1. If a word appears multiple times in one row it should only be counted once.
2. Because the data set is so large (at least 200,000 words) I would like keywords only to be displayed if they match certain user defined criteria:
a) They aren't an 'excluded keyword' such as 'and, this, that, they etc'
b) The keyword appears at least x or more times.
3. As theses script/s take a long time to run on such a large dataset I would like to include a progress indicator.
What would be the best way to do this?
Thanks so much for your help. I'm new here and if you want me to clarify anything please ask.
Bookmarks