find and copy data from column

A

akdeuce

I have a long list of data imported into one column. Each record is 13
rows. I would like to be able to type the first line of any record
into cell B1 and have it find and report the record plus 12 rows
beneath the record into C1:C13. Any suggestions?
 
J

JE McGimpsey

akdeuce said:
I have a long list of data imported into one column. Each record is 13
rows. I would like to be able to type the first line of any record
into cell B1 and have it find and report the record plus 12 rows
beneath the record into C1:C13. Any suggestions?
Click to expand...

One way:

C1: =B1
C2: =INDEX(A:A, MATCH($B$1, A:A, FALSE) + ROW() - 1)

Copy C2 down to C13.
 
Top