I described how to do frequency count with Microsoft Excel in "Frequency Count (with Microsoft Excel)". Now, I found the COUNTIF function of Microsoft Excel ignores leading zeros, even if the cell category is set to "Text". So, if "12" and "012" needs to be distinguished, some measures have to be taken to force Excel to interpret these as text instead of numbers. I added a note on this matter.
No comments:
Post a Comment