姓名欄改變 自動抓取 (13238)

J3:L7{=IFERROR(OFFSET($A$1,SMALL(IF(($E$2:$G$2=$L$2)*($E$3:$G$10>0),ROW($2:$9)),ROW(A1)),COLUMN(A1)+(MATCH($L$2,$2:$2,)-4)*(B$2<>$B$2)),"")

N3:P7{=IFERROR(OFFSET($A$1,SMALL(IF(($E$2:$G$2=$P$2)*($E$3:$G$10>0),ROW($2:$9)),ROW(A1)),COLUMN(A1)+(MATCH($P$2,$2:$2,)-4)*(B$2<>$B$2)),"")