List

  • Thread starter Thread starter Jamal Hakem
  • Start date Start date
J

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 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
Click to expand...

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


Regards
Claus B.
 
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
Click to expand...
Hi Claus
Great, it works, it works also for even and odd number? does it?
Thanks
Jam
 
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?
Click to expand...

=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.
 
Back
Top