View Single Post
 
Old 05-19-2011, 10:59 AM
Catalin.B Catalin.B is offline Windows Vista Office 2007
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

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
File Type: xlsx Copy of ExcelSheet(1).xlsx (23.6 KB, 28 views)
Reply With Quote