repeating one number

[Admin]

In C1: 24
In C2: 31

In C3 and copied down

=if(rows(c$3:c3)<=$c$2,$c$1&" of "&rows(c$3:c3),"")

is it what you are looking for ?

[azlinzi]

Or, you can put the following line in C3 and copy down:
=IF(ROWS(C$3:C3)<$C$1*$C$2,INT(ROWS(C$3:C3)/24+1),"")