every nth cell by columns not rows....

[Guest]

I just read the post 'Enter every nth cell item'. I wish to do the same but
across columns instead of down rows. Can this be done? I wish to pull out
into a new table every 3rd column cell from column c to column ez beginning
with column c, such as the value in column c, column f, column i, column l
and so on.......such that column ff=value in column c, fg=value in column f,
fh=value in column i, fi=value in column l and so on....Please help! Thank
You.

 

[Biff]

Hi!

Try this:

Enter this array formula in cell FF1 with the key combo of
CTRL,SHIFT,ENTER:

=INDEX($A1:$EZ1,SMALL(IF(MOD(COLUMN($A1:$EZ1),3)=0,COLUMN
($A1:$EZ1)),COLUMN(A:A)))

Copy across until you get #NUM! errors. Based on you
sample that should occur in cell HF1.

Biff