Hi,

I'm not sure I understand but maybe rank

=RANK(A1,$A$1:$A$100)

Mike

"DAVID Yii" wrote:

How to show that two or more students having a same CGPA?
If there are 100 students,then the top of 2 students have the same CGPA,by
ranking they both are Num 1.

then how i resolve if there are more than one students who obtained similar
results in the top students category?

i'm using INDEX(array,row_num,[colunm_num])

thanks for ur kindly help.