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
2774
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 13, 2021
465
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..

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!