Copying cells

  • Thread starter Thread starter ajohns
  • Start date Start date
A

ajohns

Hi

I would like to copy the contents of every 10th cell in a row in a
contineous column on a separate sheet. Is there a quick way of writing
the address that allows you to drag down and add a value of 10 to the
cell address?

Many thanks

Yours

Andrew J
Scotland
 
Hi Andrew
one way:
=INDEX('Sheet 1'!$1:$1,1,1+(ROW()-1)*10)
copy down. This will get you the 1st, 11th, 21st,... column in Row 1

HTH
Frank
 
Back
Top