排序 不重複日期與折讓交叉顯示 (9532)


D2{=IFERROR(INDEX(IF({1,0},B$2:B$16,"折讓"),RIGHT(SMALL(IF(IFERROR((MATCH(B$2:B$16*1,B$2:B$16*1,)=ROW($1:$15))*ISNUMBER(--B$2:B$16),),B$2:B$16/1%+ROW($1:$15)),INT(ROW(A2)/2)),2),MOD(ROW(A1)-1,2)+1),"")


留言