SOLVED

Resequencing a rank to sequential numbers without using COUNTIF?

New Contributor

Below is an example of my data and intended output.  

 

The formula that produces the data in column B is:

=SUMPRODUCT(--(A2>$A$2:$A$14)/COUNTIF($A$2:$A$14,$A$2:$A$14))+1

 

COUNTIF() for a larger dataset is to resource intensive, so I'd like to reprogram this where instead of COUNTIF(), there's a different SUMPRODUCT way to reproduce?

 

 

 

 

 

Example DataIntended Output
            11.00                   5.00
            11.00                   5.00
            11.00                   5.00
              7.00                   4.00
              7.00                   4.00
              7.00                   4.00
              7.00                   4.00
              3.00                   3.00
              3.00                   3.00
              3.00                   3.00
              3.00                   3.00
              2.00                   2.00
              1.00                   1.00
  
1 Reply
best response confirmed by mmrothsc (New Contributor)
Solution
This formula gives the result in reverse order, but I can fix that problem through other programming architecture. Thanks everyone for looking!

=IF(AND(A2=A3),B2,SUM(B2,1))