Thanks, Frank for you quick response. Works great!
Sonya

"Frank Kabel" wrote:

Hi
in D1 enter
=OFFSET($A$1,(ROW()-1)*4,0)
and copy down

--
Regards
Frank Kabel
Frankfurt, Germany

sdm wrote:
Hello,
Using Excel 2003. I am looking for a formula that will grab every 4th
item in a column and then paste it to a new column (or worksheet).
For example, cells A1, A2, ... A20 contain first names. I want to
grab every 4th name in the column and be copied to column D. Thanks
for your help.