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 **** 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" <[email protected]> wrote in message
news:[email protected]...
> 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 **** vinn joey glen rick dain ryan bill...
>
> end with:
> thom
> glen
> bill
> .
> .
> .
>
> Thanks in advance. Mike
>
>