Seqential numbering
 

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

Seqential numbering
 

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.

--
Rick (MVP - Excel)


"MrRJ" wrote in message
...
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

Seqential numbering
 

That will do it....thanks.

"Rick Rothstein" wrote:

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.

--
Rick (MVP - Excel)


"MrRJ" wrote in message
...
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