Dear Members,


The following is the table from where I am trying retrieve the desired data into Rank and Percentile column


Marks Rank Percentile Score
90 1 100
60 2
32 3
30 4
30 5
28 6
28 7
28 8
26 9
26 10
26 11
26 12
26 13
26 14

What should be the formula / code to auto insert rank depends on marks? I have tried with RANK function but when the marks are the same it skips a rank. I also need percentile rank code for the same on the third column considering all values (percentile including x)

Please help me.

Thanks

Jee