三條件 取資料 (15107)

日期：

F3{=TRIM(MID(SUBSTITUTE(SUBSTITUTE(INDEX(B:B,RIGHT(MAX(IF(A$3:A$19=D3,MMULT(1-ISERR(FIND({"ARCHIVE","REVIEW","FINAL"},B$3:B$19)),{1;2;3})/1%+ROW($3:$19))),2)),"|",":"),":",REPT(" ",19)),19,19))



留言

張貼留言