i agree with AliGW, but i do understand there are all kinds of reasons not to use a particular solution. in cell G5, change all cell reference C5 to be:
INDEX(C:C,5+(ROWS($G$5:G5)-1)*2)
so:
Formula:
=IFERROR(MID(INDEX(C:C,5+(ROWS($G$5:G5)-1)*2),FIND("Name: ",INDEX(C:C,5+(ROWS($G$5:G5)-1)*2))+6,FIND(" (",INDEX(C:C,5+(ROWS($G$5:G5)-1)*2))-FIND("Name: ",INDEX(C:C,5+(ROWS($G$5:G5)-1)*2))-6),"")
H5 would be:
Formula:
=IFERROR(--MID(INDEX(C:C,5+(ROWS($H$5:H5)-1)*2),FIND("(",INDEX(C:C,5+(ROWS($H$5:H5)-1)*2))+1,FIND(" records",INDEX(C:C,5+(ROWS($H$5:H5)-1)*2))-FIND("(",INDEX(C:C,5+(ROWS($H$5:H5)-1)*2))-1),"")
I5:
=INDEX(D:D,5+(ROWS(I$5:I5)-1)*2)
copy across to column J
Bookmarks