Here I go again! I run a fantasy racing league. I have a formula that
calculates points behind the first place player. How do I create a formula
to show points behind the next player? Here's my formula for the points
behind the leader:
=MAX(AR14,AR25,AR36,AR46,AR56,AR69,AR79,AR89,AR99)-AR14
I also show a player's rank, can (or would) that work to help calculate
this? Here's the rank formula: =RANK(AR14,AR4:AR109)
Thanks in advance!