Rank of numbers between specified range [Solved]

Ask a question talent.anand - Last answered on Oct 2, 2017 at 11:54 AM by TrowaD

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.
plus moins
Hi Talent.anand,

Create a separate table for all your ranks and then use VLOOKUP to pull the rank for a specific rank.


Best regards,
talent.anand- Sep 28, 2017 at 10:53 PM
Dear Trowa,

It's excellent, Thanks for quick reply and help. I am fully aware of vlookup but never thought of such a wonderful way to use it,
Thanks a lot for your nice suggestion and solution. I appreciate your timely help.
TrowaD 2281Posts Sunday September 12, 2010Registration date ModeratorStatus October 17, 2017 Last seen - Oct 2, 2017 at 11:54 AM
Thanks for your wonderful feedback!
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!