Selecting every 200th row
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
|