Search code examples
excelexcel-formulaauto-increment

Increase the value for Excel sheet Column value for every 5 cells

In Excel Sheet how can i Increase the value for Excel sheet Column value for every 5 cells

i want to give values in a Column

Sno testno
1   1
2   1
3   1
4   1
5   1   
6   2
7   2
8   2
9   2
10  2
11  3
12  3
13  3
14  3
15  3
16  4
17  4

For Every 5 values the value will increase. Any Forumla can do this for me.? or manually i have to Change

Solution

  • Enter this formula: =INT((ROW(E1)-1)/5)+1 into a blank cell where you want to fill the sequential numbers,

    see screenshot:

    enter image description here