Forum Discussion
Need help with Formula for incremental cell reference
This formula is in cell AR5 and filled down. The formula has to be entered with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021.
=INDEX($A$5:$A$25,SMALL(IF(NOT(ISBLANK($A$5:$A$25)),ROW($A$5:$A$25)-4),ROW(A1)))
This formula is in cell AS5 and filled across range AS5:AY7.
=INDEX($AI$5:$AI$25,COLUMN(A1)+(ROW(A1)-ROW($A$1))*7)
I assume that you don't work with Office 365 or Excel for the web. With older versions such as Excel 2013 you can apply the above formulas.
In cell AR5:
=TOCOL(A5:A25,1)
In cell AS5:
=WRAPROWS(AI5:AI25,7)
With Office 365 or Excel for the web you can enter the above formulas in cells AR5 and AS5.
- I appreciate the response, but neither of these solutions worked for me. I was hoping whatever formula I used I would be able to drag down so that it would fill the cells as the data far surpasses the snip I took. Thanks for trying though.
This formula is in cell AR5 and filled down. The formula has to be entered with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021.
=INDEX($A$5:$A$25,SMALL(IF(NOT(ISBLANK($A$5:$A$25)),ROW($A$5:$A$25)-4),ROW(A1)))
This formula is in cell AS5 and filled across range AS5:AY7.
=INDEX($AI$5:$AI$25,COLUMN(A1)+(ROW(A1)-ROW($A$1))*7)
I assume that you don't work with Office 365 or Excel for the web. With older versions such as Excel 2013 you can apply the above formulas.
- This worked perfectly! Thank you so very much!
