ArcMap question - fill series in attribute table - - comparable to Excel?

[SusanWinchell-Sweeney2]

Using the field calculator, is there a formula that will simulate the "fill series" function in Excel for a column in feature class attribute table? I need sequential numbers in a field, starting with record/row #1 through the last record in the attribute table.

When I have need of this before, I simply used the following in the field calculator:

[OID] +1 

The OID or FID typically starts with the number 0, so this works. However, my point layer was heavily edited; the OID is no longer sequential and missing several numbers.

Thank you!

Susan

[rachelg_esri]

Hello Susan!

Does the following article do what you're looking for? The article does mention that it assumes your records are in order of OID, but I'm not sure how it behaves on missing OIDs as I don't have a dataset to test with. Give this a try and let us know? Thanks!

How To: Create sequential numbers in a field using Python in the Field Calculator 

Best regards,

Rachel

Esri Support Services

[SusanWinchell-Sweeney2 · Accepted solution]

Thank you, Rachel! That's exactly what I was looking for...;-)

[rachelg_esri]

Yay! Glad we could help, Susan! Have a great rest of your day!