任一行數據輸入 提取 (10161)


J2{=IFERROR(OFFSET(D$1,SMALL(IF(MMULT(N(OFFSET(G$1:I$1,LOOKUP("嫻",I$2:I2,ROW($1:1)),)=A$2:C$99),{1;1;1})=3, ROW($1:$98)),ROW(A1)-LOOKUP("嫻",I$2:I2,ROW($1:1))+1),),"")


留言