Snasui Excel Forum

Hi Dear,

I can create sequencing number as in attached with sequence function but I use office 2019 at work.is there any formula similar to that?


Thanks

Try this formula,

C4 =IF((ROWS(C$2:C2)-1)*$B$2/$B$3>$B$2,"",(ROWS(C$2:C2)-1)*$B$2/$B$3)

Thanks