Hi everyone!
I couldn't find an answer to my problem anywhere so i decided to ask, hope you can help.
so I want assign a rank (from 1 to 10) to a range of data. so the biggest number receives rank 1 and the smallest number recieves 10. all the numbers in between should recieve a relative number from 2 to 9.
No. range A rank
1 254 8
2 546 6
3 231 8
4 863 2
5 346 7
6 798 4
7 45 10
8 363 7
9 142 9
10 865 2
11 765 4
12 968 1
13 544 6
I entered the rank column by hand to show the kind of result i am looking for. assign a rank from 1 to 10 to range. as you can see, row 1 and row 3 have the same rank, becaese they are close and they can both be ranked 8. so we can have two numbers that are ranked 1, or 10. it's relative.
I'm not sure if my explaination was confusing or not, let's see what you guys think.
thanks a lot in advance.
Bookmarks