Custom sorting & calculating average based position [Solved/Closed]

Report
Posts
1
Registration date
Friday August 28, 2015
Status
Member
Last seen
August 28, 2015
-
 oluwaridenawa -


please help me with this. i want to get the position based on average. but when i put all these in a table, all are getting jammed. please can u help me with this?it would be a great help for me

1 reply

Posts
2674
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 27, 2020
446
Hi oluwaridenawa,

Try using the formula RANK.

When the averages are in column H, formula in I4 would look like:
=RANK(H4,H$4:H$10)

Then drag the formula down to fill the rest of the position slots.

Best regards,
Trowa

it's very kind of you.tnx for your help..