Ranking and Points

**melkor6925** · 07-13-2013, 06:13 AM

Morning all,

Thank you for taking the time to read this!
I'm very new to excel to say the least so please bare with me on this. Attached is a file I require some help with.
Points breakdown 1 test.xlsx
In column E is a number each shop has been assigned for their performance. I would like column F to award point from 49 for the highest score in column E down to 1 for the Lowest score in column E.

Could someone please help with this.

Regards
Ryan

**martindwilson** · 07-13-2013, 06:18 AM

cant you just use rank()?
=RANK(Table26[[#This Row],[RSA Score]],Table26[RSA Score],1)

**melkor6925** · 07-13-2013, 06:28 AM

I don't suppose you could do this for me and upload it back? I do appolagise but when I say I have no idea or experience with what i'm doing im embarassed to say thats the case here but I havn't got the time to research even the basics before I have to use this to complete other documents.

**martindwilson** · 07-13-2013, 06:31 AM

just copy and paste the above formula into f2 of your table, it will fill the rest in automatically(well it should but it didn't the second time i tried)

**melkor6925** · 07-13-2013, 06:45 AM

Excellent thank you very much. I do appolagise for not even having the basics under grip at this point, but moving forward after today I will be spending a much larger amount of time working and learning excel.

Regards
Ryan