## Forum Discussion

# Need help with Formula for incremental cell reference

- Jan 11, 2024
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.

- BlizzCoJan 11, 2024Copper ContributorI 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.
- OliverScheurichJan 11, 2024Gold Contributor
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.

- BlizzCoJan 11, 2024Copper ContributorThis worked perfectly! Thank you so very much!