get code from some rows

[bren]

Hi


I have this data:

A B C D


1 code1 name1
2
3
4
5
6
7
8
9
10 code2 name2

I have each ten rows a code in column A and other data in the other
columns.
I want the codes that repeat each ten rows to show in column D like
this:

A B C D


1 code1 name1 code1
2 code2
3
4
5
6
7
8
9
10 code2 name2

Thank you so much

 

[Pete_UK]

Strictly speaking, your codes are appearing every 9th row, going by
your example. Is your next code on row 19? If so, then you can put
this in D1:

=INDEX(A:A,(ROW(A1)-1)*9+1)

and copy it down.

If, instead, your codes appear on rows 1, 11, 21, 31 etc, then you
will need this in D1:

=INDEX(A:A,(ROW(A1)-1)*10+1)

Hope this helps.

Pete

 

[bren]

Thank you very much. That worked great!!

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete