I seem to have run into a limitation with the rank.eg and rank.avg functions. I need to rank people on teams where ties receive the same rank and no rank number is skipped. I have attached a mockup sample file for you to see and really appreciate the help in advance!
The highlighted cells are what I'm tackling.
Bookmarks