Selecting every 200th row

  • Thread starter Thread starter Christine
  • Start date Start date
C

Christine

I need to verify information from a data dump and would like to select say
every 200th record from a Data sheet into a testing sheet. Is there a way to
get the values from cells A1, A201, etc. without typing the formulas by hand?
In my first cell in the testing sheet, I would have =Data!A1 in cell A1, and
in cell A2, could a formula read what's in my first cell and get the 200th
value down from the data sheet (something that would act like =Data!A1+200
rows)?
Thank you,
Chris
 
Tyr this in A1 of the second sheet =INDIRECT("Data!A"&ROW()*200-199)
Now copy it down the column; it will display from the Data sheet A1, A210,
A401....
best wishes
 
I modified your formula a bit using an additional column in which I have
values 1, 51, etc. =INDIRECT("Data!A"&B1") which works a bit better for my
need.

Thank you very much for your help.

Chris
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup and return sheet name also 2
Excel Need Countifs Formula Help 0
Reference(s) to worksheets for building graphs 4
Vlookup and Indirect 0
Copy link to offset sheet 5
Worksheet functions using one out of every five cells 0
Referencing formula using Indirect 4
Pulling data 1

Back
Top