Row Counting in EXCEL

[mbalent]

How do you set up a simple row count column on a spreadsheet?

Something like "COUNT(<previous cell>:1)" so you get the values
1
2
3
4
etc...

Thanks
Matt

"Nature forges everything on the anvil of time

 

[SkipVought]

Hi,

You could use the ROW() function.

You could use the COUNTA() function, by having the FIRST reference ABSOLUTE and the SECOND reference RELATIVE...
[tt]
B3: =COUNTA($A$2:A2)
[/tt]
and copy down thru you data.

Skip,

_[red][/red]

 

[mbalent]

Thanks, ROW() is just what I needed.

Matt

"Nature forges everything on the anvil of time