C2=LOOKUP(1,0/(LOOKUP(1,0/(M2:M15=B2),SUBTOTAL(2,OFFSET(I2,,,ROW(1:14))))=SUBTOTAL(2,OFFSET(I2,,,ROW(1:14))))/(K2:K15="户主"),J2:J15)
D2:G7{=INDEX(J:J,SMALL(IF(LOOKUP(1,0/($M$2:$M$15=$B$2),SUBTOTAL(2,OFFSET($I$2,,,ROW($1:$14))))=SUBTOTAL(2,OFFSET($I$2,,,ROW($1:$14))),ROW($2:$15),99),ROW(A1)))&""
A2:A7=IF(D2<>"",N(A1)+1,"")
留言
張貼留言