UKpastryart
New member
- Joined
- Jan 18, 2020
- Messages
- 2
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016
Hi all,
I have a formula which copies every nth cell in a row from one sheet to another.
The problem is, when I drag and copy the formula to the right on the other sheet it works perfectly, but it does not work when i drag it down.
The formula is =INDEX(Sheet2!$C1:$BRL1,3*(COLUMNS($A$1:A$1)-1)+1)
I have attached an example workbook.
Can anyone help please?
Thank you
I have a formula which copies every nth cell in a row from one sheet to another.
The problem is, when I drag and copy the formula to the right on the other sheet it works perfectly, but it does not work when i drag it down.
The formula is =INDEX(Sheet2!$C1:$BRL1,3*(COLUMNS($A$1:A$1)-1)+1)
I have attached an example workbook.
Can anyone help please?
Thank you