條件符合 提取且整行相聚 (14678)

B3{=IFERROR(INDEX(E$3:E$19&" "&TEXT(F$3:F$19,"YYY-MM-DD")&" "&G$3:G$19&" "&H$3:H$19&" "&I$3:I$19&" "&J$3:J$19,SMALL(IF(LEFT(E$3:E$19,4)=A$2&"",ROW($1:$17)),ROW(A1))),"")






留言