G4:G16 取不重複{=IFERROR(INDIRECT(TEXT(MIN(IF((A$3:D$3=G$3)*(COUNTIF(G$3:G3,A$4:D$18)=0)*(A$4:D$18<>"")*(A$4:D$18<>"NO 3"),ROW($4:$18)/1%+{1,2,3,4})),"!R0C00"),),"")
H4:J16=IFERROR(VLOOKUP($G4,OFFSET($A$2,SUMPRODUCT(($A$2:$D$11=H$3)*ROW($2:$11)),SUMPRODUCT(($A$2:$D$11=H$3)*{0,1,2,3}),8,2),2,),"")
留言
張貼留言