Previous Topic Next Topic

Rank of numbers between specified range

Solved/Closed
talent.anand - Sep 28, 2017 at 02:06 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 2, 2017 at 11:54 AM
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 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Sep 28, 2017 at 11:27 AM
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
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 Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Oct 2, 2017 at 11:54 AM
Thanks for your wonderful feedback!

Similar discussions

Excel Macro/Code help: Creating sheet for each name in column of another sheet
excelnovice2019 -
vcoolio -

21 responses
Copy range data in a column to new column.
anthonyishere -
anthonyishere -

6 responses
Excel if range of cell contain a text put a cell value in
diegomagum -
TrowaD -

11 responses
range of numbers
whatsit -
Mazzaropi -

3 responses
Excel Macro - Set and autofill a range?
KT -
excel987 -

28 responses