A solution can be this: in cell E6 enter this formula for the start
=IF(D6=0;"";1)
and in next row, same column:(E7)

=IF(D7=0;"";COUNTIF(E$6:E6;">0")+1)
You can copy this cell to your range (only formula without format) and it will work
you will find this solution in the modified file

Now stop surfing the net and start working :)
Your country needs you

Attached Files

Copy of ExcelSheet(1).xlsx (23.6 KB, 28 views)