多欄多行 取不重複 (15160)

M2:M16{=INDIRECT(TEXT(MIN(IF((COUNTIF(M$1:M1,A$2:J$9)=0)*ISNUMBER(FIND("Data",A$1:J$1)),ROW($2:$9)/1%+COLUMN(A:J),999)),"!R0C00"),)&""

N2:N16=IF(M2="","",SUMPRODUCT((A$2:J$9=M2)*N(+B$2:K$9)))



留言