Statistics on data

[AB]

Hi List
I have a spreadsheet that has in one column a list of occupations.
Is it possible to preprare an analysis or chart of the frequencies they
occur.
Many thanks
Althea

 

[JE McGimpsey]

One way:

Select the column and create a Pivot Table (using occupations in the row
section and count of occupations in the data section.

See

http://peltiertech.com/Excel/Pivots/pivotstart.htm


for help with PTs.

 

[AB]

Many thanks, off to study your instruction pages
Bye
Althea

 

[AB]

Solved with in 5mins, Many thanks for easy instructions
Althea