| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Points behind next rank in a fantasy league
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| RANK Function Modified? | Excel Worksheet Functions | |||
| Rank fx - Fill Down? | Excel Worksheet Functions | |||
| How to use RANK to break multiple ties. | Excel Worksheet Functions | |||
| space between y axis and data points.. | Charts and Charting in Excel | |||
| Newbie to charts question - projecting values between data points | Excel Discussion (Misc queries) | |||
Threaded Mode
