Day 19

Task:

You run an inside-sales contest for a six-person team. This quarter's numbers are in front of you and management wants each rep placed 1 to 6, best first — but the sheet feeds a dashboard that reads rows by employee ID, so the rows themselves have to stay put. Work out each rep's rank in column C. The runner-up also gets a spot bonus worth 5% of the second-highest total, which nobody has a name for yet, so work that out in B8.