| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Row Numbering | Excel Discussion (Misc queries) | |||
| PO with sequential numbering with start / end numbering | Excel Discussion (Misc queries) | |||
| how can i make invoice numbers seqential in 2000 | Excel Worksheet Functions | |||
| Numbering | New Users to Excel | |||
| numbering | Excel Discussion (Misc queries) | |||
Linear Mode
