• 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.

Rating a group

apmitch

New Member
Dear Sirs, can you please help? I have 7 groups of people with varying numbers of people in the groups. For example one group as 30 people another group 10 people. They are all arranged in their groups by an average number due to scores they take on a test. Now what I want to do is arrange the groups, like a football table, which group is the highest and which group is lowest. Based on the mean scores they have. Can some one please help?
 
Hi ,

Can you upload your file ?

You can use the RANK function , but in order to give an accurate formula , your data layout needs to be available.

Narayan
 
Back
Top