Cell contents to reflect Row Number

[Colin Hayes]

Hi All

Hope someone can help.

I need each of the cells in column A to show a number which reflects the
row they are in.

For example A1 would show 1 , A2 would show 2 and so on.

Does anyone know the formula I should put in the formula bar for this to
happen?


Best Wishes

Drno

 

[JE McGimpsey]

One way:

=ROW()

 

[RagDyeR]

Try this:

=ROW()
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



Hi All

Hope someone can help.

I need each of the cells in column A to show a number which reflects the
row they are in.

For example A1 would show 1 , A2 would show 2 and so on.

Does anyone know the formula I should put in the formula bar for this to
happen?


Best Wishes

Drno

 

[Colin Hayes]

Try this:

=ROW()

HI

OK That's done it. Thanks again.

Drno

 

[reno]

try the row() function.

you would use =row()-x, where x is the subtrahend to make the number equal
the row number. for example if your row 1 as headings and your data started
in row two you would use row()-1, if your heading took up rows 1 thru 4 then
it would be =row()-4.

this also works when you sort the rows, as they will always be numbered
sequentially.
Bob