Google Answers Logo
View Question
 
Q: Excel Spreadsheet, Extracting field from every tenth row ( No Answer,   4 Comments )
Question  
Subject: Excel Spreadsheet, Extracting field from every tenth row
Category: Miscellaneous
Asked by: pog258-ga
List Price: $2.00
Posted: 06 Nov 2006 09:00 PST
Expires: 06 Dec 2006 09:00 PST
Question ID: 780522
I have a column with say 100 rows of various numbers. In another
column I want to set it up so that it takes the number from first row
and copies it to say B1 then want to put the number from 11th row and
put in in B2, then number from 21st row and put it in B3 etc.
Please help.
Mike
Answer  
There is no answer at this time.

Comments  
Subject: Re: Excel Spreadsheet, Extracting field from every tenth row
From: reinedd-ga on 06 Nov 2006 09:43 PST
 
Col A 
   your data column
Col C 
   you put in C1:  =1  in C2 you put =c1+10, you copy c2 and you paste
it for as many number as you want
Col B
   col b1 you put ="a"&c1 you copy b1 and you paste it for as many
number as   you want
  you select the col B and you do copy and paste special, value
  
  you should get something like

  =a1
  =a11
  =a21 etc

  now to convert it to formula

  you select the column B you go to data, text to column and you do
next next  finish


good luck
Subject: Re: Excel Spreadsheet, Extracting field from every tenth row
From: reinedd-ga on 06 Nov 2006 09:44 PST
 
Col A 
   your data column
Col C 
   you put in C1:  =1  in C2 you put =c1+10, you copy c2 and you paste
it for as many number as you want
Col B
   col b1 you put ="=a"&c1 you copy b1 and you paste it for as many
number as   you want
  you select the col B and you do copy and paste special, value
  
  you should get something like

  =a1
  =a11
  =a21 etc

  now to convert it to formula

  you select the column B you go to data, text to column and you do
next next  finish


good luck
Subject: Re: Excel Spreadsheet, Extracting field from every tenth row
From: reinedd-ga on 06 Nov 2006 09:45 PST
 
Sorry forget the fist one
Subject: Re: Excel Spreadsheet, Extracting field from every tenth row
From: barneca-ga on 06 Nov 2006 14:15 PST
 
it's easier than that.  assuming your data is in column A, try this
formula in column B:

=INDEX(A:A,ROW()*10-9)

it works in excel 2003, at least.

-cab

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy