Ranking

  • Thread starter Zainuddin Zakaria
  • 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.
 
D

delfiled

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

2. Use rank function on composite score.

dave y.
 
Top