Getting rank of student based on test scores

[ppvtuser]

I have a powerpivot table with N student names and their grade. How do I calculate the rank of the student?

Table1
Grade Rank
85 1
82 2
79 3
65 4
... ...
5 N

 

[masplin]

Assuming you have 2 columns "Grade" with score and "Name" with names. Create a new column with this

=RANK.EQ(table1[Grade],table1[grade],0)

Mike