ããçä¸è¾¹ä¾åï¼C2å ¬å¼=SMALL(IF(IFNA(MATCH(ROW(INDIRECT(A$2&":"&A$18)),A$2:A$18,),),"",ROW(INDIRECT(A$2&":"&A$18))),ROW(A1))ï¼åªè¦æ¯Aåæ°æ®ååºæåï¼èµ·æ¢æ°å¼éææ¹å¨ï¼åå¯ï¼å¦æèµ·æ¢æ°æ®ä¸éè¦åå¨ï¼å¯å°å ¬å¼ç®å为=SMALL(IF(IFNA(MATCH(ROW($1:$26),A$2:A$18,),),"",ROW($1:$26)),ROW(A1))
ããDåå ¬å¼ä¸º=WORKDAY.INTL(0,ROW(A1),"0000000",A$2:A$18)ï¼è®¡ç®ç»ææ 线å¢å¤§ï¼åå°äºAåæ大å¼ä»¥åçæ°å³å¯ã