E2:E22{=INDEX(A:A,SMALL(IF(B$2:B$26<>"户主",LOOKUP(ROW(2:26),ROW(2:26)/(B$2:B$26="户主"),ROW($2:$26)),99),ROW(A1)))&""
F2:G22=IF($E2="","",OFFSET(A$1,MATCH($E2,$A:$A,)+COUNTIF($E$2:$E2,$E2)-1,))
F2:G22另解{=INDEX(A:A,SMALL(IF($B$2:$B$26<>"户主",ROW($2:$26),99),ROW(A1)))&""
留言
張貼留言