Quote Originally Posted by xld
I think you have it back to front MD.

I would insert a row #1 in Data, and then in M2

=IF(L2="",M1,MATCH(L2,temp!$D:$D,0))

copy down. Filter column M on the #N/A and delete them
hmm. i think i can probably make that work. all but teh filter part anyway.

there is more data and junk in columns A:I that i ommited but for each row that has a value in L, there could be 2-6 rows of data for that item. the only think i know for SURE is that the record starts where you see an item in L and ends the row above the next item in L.