Seqential numbering

[MrRJ]

Hello,
I need assistance. Looking for a formula that would number the rows
sequentially given a criteria of zero.

Example
Column A has a series of values all the way to row 500. I only wish to
capture ZERO (0) and then number them sequentially.

Thanks,
MrRJ

 

[Rick Rothstein]

Does this formula, copied down, do what you want?

=IF(A1=0,COUNTIF(A$1:A1,0),"")

If not, you will need to clarify your question for us.

 

[MrRJ]

That will do it....thanks.

Does this formula, copied down, do what you want?

=IF(A1=0,COUNTIF(A$1:A1,0),"")

If not, you will need to clarify your question for us.