彙整 二項值相同相聚 (13148)

(2007) D2:D10=IFERROR(LOOKUP(1,0/(B$1:B1=B2)/(C$1:C1=C2),D$1:D1)&","&A2,A2)

G3:K7=IFERROR(LOOKUP(1,0/($B$2:$B$10=$F3)/($C$2:$C$10=G$2),$D$2:$D$10),"")



留言