offset every nth column

[Guest]

Refer to post Every nth cell. I need this to work for every third column
instead of row but can not get the formula to work. I want to type in the
formula and copy it right to pull every third column's value. The formula
used in the previously referenced post is offset.

 

[Peo Sjoblom]

One way

=OFFSET($A$3,,COLUMN(A:A)*3-3)

copied across to the right

--


Regards,

Peo Sjoblom

 

[Guest]

One way

=OFFSET($A$3,,COLUMN(A:A)*3-3)

copied across to the right

--


Regards,

Peo Sjoblom





This Works Perfectly. Thank you for your Help. It is much appreciated.