Creating frequency lists in Excel

[peiceslaura]

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

 

[Gary''s Student]

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