提取二區二列唯一值 (9136)


K3:L13{=IFERROR(OFFSET(A$1,SMALL(IF((COUNTIFS($K$2:$K2,$A$3:$A$13,$L$2:$L2,$B$3:$B$13)=0)*($A$3:$A$13<>""),ROW($2:$12)),1),),OFFSET(F$1,SMALL(IF(COUNTIFS($K$2:$K2,$F$3:$F$13,$L$2:$L2,$G$3:$G$13)=0,ROW($2:$12)),1),)&"")


留言