Microsoft@Joe McDaid @HennSarv @lori_m @Sergei Baklan @Wyn Hopkins @Bill Jelen @Detlef Lewin
| 200405-24Q4 | =COUNTIF($A$1:$A1,$A1) | 1 |
| 200506-24Q1 | =COUNTIF($A$1:$A2,$A2) | 1 |
| 200506-24Q2 | =COUNTIF($A$1:$A3,$A3) | 1 |
| 200506-24Q3 | =COUNTIF($A$1:$A4,$A4) | 1 |
| 200506-24Q4 | =COUNTIF($A$1:$A5,$A5) | 1 |
| 200405-24Q4 | =COUNTIF($A$1:$A6,$A6) | 2 |
| 200405-24Q4 | =COUNTIF($A$1:$A7,$A7) | 3 |
| 200405-24Q4 | =COUNTIF($A$1:$A8,$A8) | 4 |
| 200506-24Q1 | =COUNTIF($A$1:$A9,$A9) | 2 |
| 200506-24Q2 | =COUNTIF($A$1:$A10,$A10) | 2 |
| 200506-24Q3 | =COUNTIF($A$1:$A11,$A11) | 2 |
| 200506-24Q4 | =COUNTIF($A$1:$A12,$A12) | 2 |
| 200405-24Q4 | =COUNTIF($A$1:$A13,$A13) | 5 |
| 200405-24Q4 | =COUNTIF($A$1:$A14,$A14) | 6 |
| 200506-24Q1 | =COUNTIF($A$1:$A15,$A15) | 3 |
| 200506-24Q2 | =COUNTIF($A$1:$A16,$A16) | 3 |
| 200506-24Q3 | =COUNTIF($A$1:$A17,$A17) | 3 |
| 200506-24Q4 | =COUNTIF($A$1:$A18,$A18) | 3 |
| 200405-24Q4 | =COUNTIF($A$1:$A19,$A19) | 7 |
| 200405-24Q4 | =COUNTIF($A$1:$A20,$A20) | 8 |
| 200405-24Q4 | =COUNTIF($A$1:$A21,$A21) | 9 |
| 200405-24Q4 | =COUNTIF($A$1:$A22,$A22) | 10 |
Instead of using COUNTIF in each row, how any dynamic formula (like SEQUENCE) can be used to enable the COUNTIF function to behave like a Dynamic Array Formula and spill the desired totals into the entire range to calculate the running countif ?
Thanks
Kanwaljit
