In the attached, there are 500 names in order of ranking(column A) from 1 to 500
I would like to assign each name a rating from 2700 to 1500 (column L) based on its ranking(column A)
That means, for example the highest ranked (pos. 1) will have ~2700 rating, and the lowest ranked (pos 500) will have ~1500 rating.
I've made a rough example in column C.
Thanks for any help.
Last edited by bibu; 09-05-2014 at 12:03 PM.
Like attached?
Exactly what I needed, gracias!
This solves the problem without using tables.
This subtracts the bottom value from the top value and divides by the number of "divisions" - 1 because the first one isn't divided and is multiplied by the rank as determined by the starting row being 0.
Formula:
Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Hi, sorry for not replying faster, this also gets the job done nicely, thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks