Creating frequency lists in Excel
 

If I have a column of different variables, how do I tell Excel to give
me a list of what variables are in that column and their frequency?

Laura

Creating frequency lists in Excel
 

Excel has a feature to perform this - Pivot Table

Say column A has data like:

Animals
cat
cat
dog
dog
dog
mouse
mouse
..
..
..

A Pivot table can list each animal and how often it appears in the column.
See:

http://peltiertech.com/Excel/Pivots/pivotstart.htm
--
Gary''s Student - gsnu2007c


" wrote:

If I have a column of different variables, how do I tell Excel to give
me a list of what variables are in that column and their frequency?

Laura