Excel not recognizing pattern // create formula to skip rows

[pmf13]

Hi there,

I have read several threads on the topic but haven't been able to figure out this issue so far:

I am trying to reference cells from one sheet to another, with the following pattern:

A1
A2
A4
A5
A7
A8

I.e., read 2 rows, skip one, read 2 rows, skip one...and so forth.

I am new to excel, and haven't been able to figure out how to use the OFFSET formula to achieve this. Can anyone help me?

Thank you!!

 

[jammoca]

Let's say your data is in column A, then in C1 enter ... =INDIRECT("A"&IF(MOD(ROW()-1,2)=0,OFFSET(A1,INT((ROW()-1)/2),0),OFFSET(A1,INT((ROW()-1)/2),0,))) ... and drag down

Kind regards,

Chris

 

[Leo Skywalker]

Use this in the results Sheet:

=INDEX(Sheet1!$A$1:$A$200,ROUNDUP(ROW(A1)/2,0)-1+ROW(A1))

Sheet1 is the name of the data sheet
$A$1:$A$200is the range where data is allocated
A1 is a row reference that has to coincide with the first value you want.