Custom sorting & calculating average based position

Solved/Closed
oluwaridenawa Posts 1 Registration date Friday August 28, 2015 Status Member Last seen August 28, 2015 - Aug 28, 2015 at 11:24 PM
 oluwaridenawa - Aug 31, 2015 at 10:07 PM


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

TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 523
Aug 31, 2015 at 11:58 AM
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
0
oluwaridenawa
Aug 31, 2015 at 10:07 PM
it's very kind of you.tnx for your help..
0