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
oluwaridenawa - Aug 31, 2015 at 10:07 PM
Related:
- Custom sorting & calculating average based position
- Ultimate custom night - Download - Horror
- Custom resolution utility - Download - Customization
- Dino game custom character - Guide
- Based on the values in cells b77 ✓ - Excel Forum
- Sims 2 custom content not showing up ✓ - The Sims Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Aug 31, 2015 at 11:58 AM
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
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
Aug 31, 2015 at 10:07 PM