202212031827不重複 提取 (10829)

G5{=IFERROR(RIGHT(SMALL(IF(COUNTIF(G$4:G4,B$5:D$7)=0,{1;2;3}/1%+{1,2,3}/1%%+B$5:D$7),1))*1,"")

N5{=IFERROR(INDIRECT(TEXT(RIGHT(SMALL(IF(COUNTIF(N$4:N4,J$5:L$7)=0,{5;6;7}/1%+{10,11,12}*10001),1),4),"!R0C00"),),"")

利用日期 H5{=IFERROR(INDIRECT(TEXT(SMALL(IF(COUNTIF(H$4:H4,B$5:D$7)=0,DATE(,{2,3,4},{5;6;7})),1),"!rdcm"),),"")

沒有上一則|日誌首頁|沒有下一則
回應
關鍵字
    沒有新回應!
    blank