start numbring from 1 to 10 and 1to10 .etc

**abdi1** · 10-03-2011, 05:33 AM

hi
i want to start numbring in excel colomn i cell 16
like this

Please Login or Register  to view this content.

i have many data and it may be 10000 cell and want
to do this in quick way
any help plz?

**Richard Buttrey** · 10-03-2011, 05:40 AM

Hi,

=MOD(ROW()-16,10)+1

and copied down

Regards

**abdi1** · 10-03-2011, 05:46 AM

Originally Posted by Richard Buttrey

Hi,

=MOD(ROW()-16,10)+1

and copied down

Regards

hi
thanks for u Richard
i will tray this

**Marcol** · 10-03-2011, 07:11 AM

Another possibility

Please Login or Register  to view this content.

Note
Microsoft lists ROW() as a volatile function, but this doesn't appear to be true in practice.

Re: start numbring from 1 to 10 and 1to10 .etc