List

[Jamal Hakem]

Hi
I have texts in A8, A12, A16, etc every 4 rows in one sheet, how to have these texts in D8,D9,D10 etc in other sheet
Thanks in advance
Jam

 

[Claus Busch]

Hi Jam,

Am Thu, 2 Jan 2014 08:39:47 -0800 (PST) schrieb Jamal Hakem:

I have texts in A8, A12, A16, etc every 4 rows in one sheet, how to have these texts in D8,D9,D10 etc in other sheet

in D8 in Sheet2:
=INDEX(Sheet1!A:A,(ROWS($1:1)-1)*4+8)
and copy down


Regards
Claus B.

 

[Jamal Hakem]

Hi

I have texts in A8, A12, A16, etc every 4 rows in one sheet, how to have these texts in D8,D9,D10 etc in other sheet

Thanks in advance

Jam

Hi Claus
Great, it works, it works also for even and odd number? does it?
Thanks
Jam

 

[Claus Busch]

Hi Jam,

Am Thu, 2 Jan 2014 11:42:23 -0800 (PST) schrieb Jamal Hakem:

Great, it works, it works also for even and odd number? does it?

=INDEX(Sheet1!A:A,(ROWS($1:1)-1)*4+8)
In this formula *4 is the distance of your cells (you want values of
every 4. cell) and +8 is the start cell.
Sheet1!A:A is the matrix where your values are. (Rows($1:1)-1) is the
counter. For the first row it is 0 and will be increased by 1


Regards
Claus B.