Custom sorting & calculating average based position
Solved/Closed
oluwaridenawa
Posts
1
Registration date
Friday 28 August 2015
Status
Member
Last seen
28 August 2015
-
28 Aug 2015 à 23:24
oluwaridenawa - 31 Aug 2015 à 22:07
oluwaridenawa - 31 Aug 2015 à 22:07
Related:
- Average position
- Potplayer remember playback position - Guide
- Average life of plasma tv - Guide
- Kmplayer remember last played position - Guide
- Average antivirus free download - Download - Antivirus
- Check my position address on google maps - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
31 Aug 2015 à 11:58
31 Aug 2015 à 11:58
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
31 Aug 2015 à 22:07