Ranking

  • Thread starter Thread starter Zainuddin Zakaria
  • Start date Start date
Z

Zainuddin Zakaria

Hi all,

I want to RANK students' position in class according to their 'average mark'
in Column Z.
If the average mark is same of two or more students, then RANKING (position)
is based their 'Ggrade Point Average' which is lieted in in Column Y.
If it is still the same, the rank should be based on Subject 1 in Column X.

Can someone suggest a formula for that?

Thank you in advance.
 
1. Construct a composite score column.
e.g. AA = 1000000*Z + 1000*Y + X

2. Use rank function on composite score.

dave y.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to finding student Rank and How to upload bulk marks of each student at a time. 1
Breaking Ties in Ranking 4
AverageIFs 4
RANK based on result and average 5
RANK - dont include zeros 5
Ranking without skipping ranks and percentile 3
Ranking and Allocating points 4
RANK and assigning a value in another column 1

Back
Top