One possible way


=INDEX(B:B,ROWS($A$1:A1)*10-9)

will return what's in B1, B11, B21 and so on when you copy it down

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"suzie" wrote in message
...
I have tried to create another column by starting the pattern b1, b11, b21,
b31 and tried to continue the pattern by using the fill handle and using
fill
series, but both of these restart the pattern using a different cell. I
don't
know what else I can try.