Forum Discussion
Solved
Need help with Formula for incremental cell reference
This issue has 2 piece's: I have been trying to figure out this formula for a while now. I am attempting to get the initials from Column A (that are every 7 rows) in order in Column AR....
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.
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!