offset every nth column

G

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.
 
P

Peo Sjoblom

One way

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

copied across to the right

--


Regards,

Peo Sjoblom
 
G

Guest

Peo Sjoblom said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top