INDIRECT function - need help

Originally Posted by dansparts

Column C is where the values for A4, A18 and A32 and so on need to wind up.
Column E is where the values for A6, A20 and A34 and so on will go.
...from A4 needs to show up in C3, value from A18 in C4, etc.

No attachment?
Anyway, with some basic info, I tried:
In A6:

=IF(MOD(ROW(3:3)-1,14)=0,OFFSET($C$3,INT((ROW(3:3)-1)/14),),IF(MOD(ROW(3:3)-1,14)=2,OFFSET($E$3,INT((ROW(1:1)-1)/14),),""))

Copy up to A4:A5 and down to A7 to as far as you want

If it does not help, try to attach a sample file.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Untitled.png

P/S:have seen attachment now. Working on this.