I have following scenario.
I have numbers grouped by 8 same values and then I want next 8 values to raise by 1.
Example:
4
4
4
4
4
4
4
4
5
5
5
5
5
5
5
5
I tried few suggestions, but I can't get it to work. :(
When I just drag selected values, it does the work, but ads few extra values.
=const1+INT((ROW()+const2)/8)
. For example while starting from A1 const1=3, const2=7.