Word Count in Excel

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar
2253 S. Oneida
Ste 3D
Denver, CO 80224

We help people think!

Copyright © 2008

A lot of interesting data is concealed in comments entered by service representatives. Word count parses the words out of sentences and paragraphs and uses Pivot Tables to count the occurrences of individual words and sort them in descending order:

Original Comments

Word Count
(Note: From these comments the most likely cause of rejected claims--was determined to be overlapping dates of service [dos]).

Other Data Transformation Tools

The Word Count function is just one of the tools included in the QI Macros for Excel SPC Software for Excel.

Download the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six Sigma

Download
FREE
30-Day Trial

Or Buy It Now!
Unconditional
90-Day
Money-Back
Guarantee