View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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.