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)

Thank you Catalin! This works perfectly!

Glad to help
Ilkks, that was simple, we expect you to do greater things... Almost any work can be simplified with the right approach...