Separating the Data Slot wise

[arshad.99.ali]

Hi,

I am trying to prepare slot numbers with a variant of 10 with MOD formula but couldn't able to get it.

i attached sample data with expected output

Any one can please provide solution

Thanks in Advance......

[Phuocam]

Try this ...

=CEILING(ROWS($F$2:F2)/10,1)

[arshad.99.ali]

Perfect Solution.......

Thank you.......

[Phuocam]

You're welcome!