每户信息統計,户主姓名在最底部 (14429)

(先)F3{=IFERROR(SMALL(IF(B$3:B$39="户主",ROW($1:$37)),ROW(A1))-SUM(F$2:F2),"")

D3=IF(F3="","",OFFSET(A$2,SUM(F$3:F3),))

E3=IFERROR(LOOKUP(1,0/MMULT(N(OFFSET(B$2,SUM(F$3:F3),,-F3)={"妻子","丈夫"}),{1;1}),OFFSET(A$2,SUM(F$3:F3),,-F3)),"")