Ranking

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

[[email protected]]

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

2. Use rank function on composite score.

dave y.