H4:H50=IFERROR(LOOKUP(1,0/(LOOKUP(9^9,A$3:A4)=LOOKUP(ROW($1:1),ROW($1:1)/(A$3:A3<>""),A$3:A3))/(G$3:G3=G4),H$3:H3)&F4,F4)&" "
K4:L50=IFERROR(SUBSTITUTE(TRIM(LOOKUP(1,0/(LOOKUP(ROW($4:$50),ROW($4:$50)/($A$4:$A$50<>""),$A$4:$A$50)=$J4)/($G$4:$G$50=K$3),$H$4:$H$50))," ","、"),"")
留言
張貼留言