title: How to increment rows only using the ROW() function and an Increment value?
body: <p>I have searched all over but have not found an answer to this particular question. I have spent hours on this and have not come up with a solution.</p>
  
  <p><a href="https://i.stack.imgur.com/TSQeD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/TSQeD.png" alt="Increment Problem"></a></p>
  
  <p>What formula will yield the results shown in the yellow region, column K, that only uses the ROW() function and the cell reference (H18) which contains the Increment Value in the formula?</p>
  
  <p>For example: the desired results shown in column K should match the values in the green area in column G using the Increment value of 5.</p>
  
  <p>When the Increment value is later changed to 6, the results should match the values in Column H, and so on...</p>
  
  <p>Note: The formula cannot use references to any other cells except itself. The initial formula will entered in cell K1 and then be copied downwards to yield results as shown in the yellow region.</p>
  
  <p>In addition, this should be a formula type answer and not a VBA solution.</p>
  
  <p>Two Failed example formulas:
  =inc*(ROW()-1), and =(row+inc)
  where defined names: inc = $H$18 and row = ROW()-1</p>
  
  <p>BTW... I am using Excel 2000</p>
  
  <p>Thanks in advance</p>