Find Rank of marks from specified range

[talent.anand]

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 accordingly as if student scores between 91.5-91.7 he gets 1 rank and so on.

 

[NARAYANK991]

Hi ,

Please upload your workbook , with much more data covering a larger range of marks and specifying the range for each rank.

Narayan