I'm trying to breakdown a formula that a previous coworker had put in but cannot figure out why the -1 was inserted into this formula.
The sheet is intended to randomize numbers and assign it to an associate of our company.
This is the formula we're working with: =RANK.EQ(B6,B:B)+COUNTIF($B$2:B6,B6)-1