Incremental number every 10 row

[sythong]

Hi guys

I am trying to get a batch number for every 10 rows. After searching
I managed to find one that gives

=E7+OFFSET(H$7,INT((ROW(H7)-7)/7),0)

To adapt to my requirements, I substitute 7 with 10 but it doesnt seems
to give the answer which is to change this number every 10 rows. Right
now I have to manually key in repeatedly the same batch number every
10th row i.e. where I have 50 rows the batch will be 1 for row A1-A10,
11 for A11-A20 and so forth

Please advise how to modify it so that it can be flexible enough for any
number of rows not necessarily 10.

Thanks

 

[Andrew Poulsom]

Try:

=(INT((ROW(A1)-ROW(A$1))/10)*10)+1

 

[p45cal]

beaten to it by Andrew, my offering:
=INT((ROW()-ROW(F$34))/10)*10+1
but the F$34 should be changed to a refence to any cell in the same row as the topmost formula, retaining the $ character. Copy down.
Change the two instances of 10 to another value for your flexibility.

 

[sythong]

Andrew & p45cal

Thanks it seems to be working now.