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 another 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)
Can anyone help please?
Thank you
Also posted here: https://www.excelguru.ca/forums/show...king-correctly
Bookmarks