how do I copy the contents of every 10th cell?
 

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.

how do I copy the contents of every 10th cell?
 

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.

how do I copy the contents of every 10th cell?
 

suzie

=OFFSET($A$1,10*ROW()-10,0)

Entered in B1 and dragged down column B will give you contents of A1, A11, A21
etc.


Gord Dibben MS Excel MVP

On Tue, 13 Jun 2006 18:30:01 -0700, suzie
wrote:

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.

how do I copy the contents of every 10th cell?
 

Hi Suzie,

Another way is to put numbers 1 to 10 (i.e. 1 in A1, 2 in A2 etc.) in a
blank column then copy them down to the end of your data and then
use autofilter to select every tenth row.

HTH
Martin