get code from some rows

  • Thread starter Thread starter bren
  • Start date Start date
B

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