progressive select
 

Looking for help on a function to create of a single column of data by
selecting every 4th cell in a fixed row starting with the second column in
the fixed row.

Example: start with:
a1 b1 c1 d1 e1 f1 g1 h1 i1 j1
mike thom dick vinn joey glen rick dain ryan bill...

end with:
thom
glen
bill
..
..
..

Thanks in advance. Mike

Hi!

Try this:

=OFFSET(B$1,,(ROW(1:1)-1)*4)

Copy down as needed.

Biff

"Mike" wrote in message
...
Looking for help on a function to create of a single column of data by
selecting every 4th cell in a fixed row starting with the second column in
the fixed row.

Example: start with:
a1 b1 c1 d1 e1 f1 g1 h1 i1 j1
mike thom dick vinn joey glen rick dain ryan bill...

end with:
thom
glen
bill
.
.
.

Thanks in advance. Mike