Custom sorting & calculating average based position

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 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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:

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

Best regards,
Aug 31, 2015 at 10:07 PM
it's very kind of you.tnx for your help..