Find Rank if number falls between a range

Dear Sir,

I have following data

Marks      Desired Rank

91.3             2

91.4             2

91.5             1

91.7             1

90.0             3

89.4             5

89.5             4

82.3             6

82.4             6

 

I want to find rank accordinly as if student scores between 91.5-91.7 he gets 1 rank and so on.

 

By: Anand Sharma

Leave a Reply

Your email address will not be published. Required fields are marked *