Jul 31 2021 03:08 PM
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 |
Jul 31 2021 06:43 PM
SolutionJul 31 2021 06:43 PM
Solution