i have a excel spreadsheet that is a leaderbourd
i would like to make it so that the position in points is calculated automaticaly i.e so the position of the highest scoring person is 1 then next 2 ect
so the points won are in row K 2-51 and the position would be in row L 2-51
if possible i would then like the spreadsheet to automaticaly put the competitors into order by position
is this possible
i would like to make it so that the position in points is calculated automaticaly i.e so the position of the highest scoring person is 1 then next 2 ect
so the points won are in row K 2-51 and the position would be in row L 2-51
if possible i would then like the spreadsheet to automaticaly put the competitors into order by position
is this possible