Possible to calculate frequency of non-numeric data ?

  • Thread starter Thread starter Android
  • Start date Start date
A

Android

I need to read columns of non-numeric data, and populate another location
(on same sheet, or another one), the frequency of occurance of data, the %
versus total, etc.

For example, one data column could be:

Student
Professor
Lecturer
Student
Student


If there is a function to calculate the frequency of data such as this, I
will be able to create a table such as this:

Parameter Frequency %
---------- ----------- -----
Student 3 60
Professor 1 20
Lecturer 1 20

Total 5 100

Is there a way to do this without use of VBA?
 
The problem with the pivot tables are that:
- They require more than 1 columns. Is there a way to get the data with the
1 column I need?. I tried the links you sent me.
- It requires contiguous data. Ie., even in cases where I can use 2 or more
columns, they need to be together

Android.

Frank Kabel said:
Hi
one way would be to use pivot tables to calculate frequence and % of
specific entries. For some instructions on pivot tables have a look at:
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.cpearson.com/excel/pivots.htm

HTH
Frank


Android wrote:
[snip]
If there is a function to calculate the frequency of data such as
this, I will be able to create a table such as this:

Parameter Frequency %
---------- ----------- -----
Student 3 60
Professor 1 20
Lecturer 1 20

Total 5 100

Is there a way to do this without use of VBA?
Click to expand...
Click to expand...
 
I stand corrected. I see that 1 coulmn can be used.

Thanks for your help.

Android.

Android said:
The problem with the pivot tables are that:
- They require more than 1 columns. Is there a way to get the data with the
1 column I need?. I tried the links you sent me.
- It requires contiguous data. Ie., even in cases where I can use 2 or more
columns, they need to be together

Android.

Frank Kabel said:
Hi
one way would be to use pivot tables to calculate frequence and % of
specific entries. For some instructions on pivot tables have a look at:
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.cpearson.com/excel/pivots.htm

HTH
Frank


Android wrote:
[snip]
If there is a function to calculate the frequency of data such as
this, I will be able to create a table such as this:

Parameter Frequency %
---------- ----------- -----
Student 3 60
Professor 1 20
Lecturer 1 20

Total 5 100

Is there a way to do this without use of VBA?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top