One way
=OFFSET($A$3,,COLUMN(A:A)*3-3)
copied across to the right
--
Regards,
Peo Sjoblom
"Sampson" wrote in message
...
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.
|