• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Tabulation and count

S

Serene

Member
Hi everyone,


I have a sheet where I have rows containing staffid, Job grade and appraisal score.

I would like to analyse the tendency of the scoring by the different job grade.

To do this, first I would like to recompile the table so I have the no of people by Job Grade who have been graded - Excellent, Good, Satisfactory, Fair and Poor.


Is there an efficient way to go about doing this.

What if I use simple count. How do I use the countif function to pick the two criteria, by Job Grade and Appraisal Score.


Thanks in advance!


Serene
 
Serene


Why not select your data area and Insert a Pivot Table/Pivot Chart


This will enable you to visually drag fields around and do exactly what your suggesting
 
Dear Hui

Thanks, I am trying out pivot table but am encountering some sorting problems which I will post another topic


Cheers

Serene
 
Hi Serene,


I know you have posted on some other thread as well regarding this question, if you could upload a sample file, hopefully it get resolved with pivot.


Faseeh
 
Good day Serene


You may find this doc of use


https://dl.dropbox.com/u/75495784/Group%20a%20Pivot%20Table.docx
 
Thanks a lot for such a good explanations and wonderful presentation.. Love you all and of course CHANDOO for creating a platform where intelligence and creativity can be expressed and appreciated. Peace, happiness and love to you all....
 
You must log in or register to reply here.
Back
Top