| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating lists | Excel Discussion (Misc queries) | |||
| creating lists | Excel Discussion (Misc queries) | |||
| Access or Excel for contact info lists & creating mailing labels | Excel Discussion (Misc queries) | |||
| Creating Pull Down Lists in Excel cells. | Excel Discussion (Misc queries) | |||
| creating lists | New Users to Excel | |||
Linear Mode
