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 Data | Intended 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 |
| | |
