title: How to create repeating sequence of values along a column in Excel?
body: <p>I want the data to be values repeating every 8 times like in the attached screenshot.</p>
  
  <p>I used the formula =ROUNDUP(ROW()/8,0) but it only works properly when the formula begins in the first row. Since I need to use the repeating data multiple times within a column when I copy-paste the formula, it doesn't start with "1". The following image is what I want. What am I doing wrong? </p>
  
  <p>What formula would let me simply copy-paste it at any point in a column and drag down to create a set of sequentially repeating numbers starting from 1 repeating 8 times each?</p>
  
  <p><a href="https://i.stack.imgur.com/JJjOV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/JJjOV.png" alt="Excel screenshot"></a></p>