I am using the unique rank.eq function to rank account numbers based on sales. I have about 6,000 rows and there are tons of duplicate sales numbers. The unique rank works for all but 5 rows, where the rank is duplicate, but the sales number is not. I can't figure out why this isn't working properly.
=IFERROR(ROUNDUP(RANK.EQ(C2,C$2:C$5980)+COUNTIF(C$2:C2,C2)-1,0),"")
Column A is the rank
Column B is the account #
Column C is the sales figure
Duplicate rank in rows 1057 & 1058, 2840 & 2841, 3532 & 3533, etc.
=IFERROR(ROUNDUP(RANK.EQ(C2,C$2:C$5980)+COUNTIF(C$2:C2,C2)-1,0),"")
Column A is the rank
Column B is the account #
Column C is the sales figure
Duplicate rank in rows 1057 & 1058, 2840 & 2841, 3532 & 3533, etc.