Rank of numbers between specified range [Solved/Closed]

Report
-
Posts
2761
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2021
-
Hello,


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.

1 reply

Posts
2761
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2021
462
Hi Talent.anand,

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

Example:


Best regards,
Trowa
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.
Posts
2761
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2021
462
Thanks for your wonderful feedback!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!