Repeat number

[shimaa01234]

I want to repeat the number, depending on the number in the column

[zbor]

In C2 write first page number:

Please Login or Register  to view this content.

In C3 write:

Please Login or Register  to view this content.

and extend formula down.

[samba_ravi]

c2=LOOKUP(ROW(A1),SUBTOTAL(9,OFFSET($B$2,-1,0,ROW(INDIRECT("1:"&ROWS($B$2:$B$7))),1))+1,$A$2:$A$7)
try this and copy towards down

[zbor]

In case that page name is not in ascending order by 1
for example:

Please Login or Register  to view this content.

Then use:

Please Login or Register  to view this content.

[shimaa01234]

Great solutions
Thank you Mister "zbor"
Thank you Mister "Siva"
Formulas works like a charm.
God bless you all, my teachers

[samba_ravi]

you are welcome and thanks for the reputation