E5{=IF(RIGHT(SMALL(IF(B$5:B$22+(B$5:B$22>1)>=COLUMN(A:I),ROW($1:$18)/1%+COLUMN(A:I)),ROW(A1)))-1=0,OFFSET(C$4,SMALL(IF(B$5:B$22+(B$5:B$22>1)>=COLUMN(A:I),ROW($1:$18)),ROW(A1)),),"")
E5{=IF(RIGHT(SMALL(IF(B$5:B$22+(B$5:B$22>1)>=COLUMN(A:I),ROW($1:$18)/1%+COLUMN(A:I)),ROW(A1)))-1=0,OFFSET(C$4,SMALL(IF(B$5:B$22+(B$5:B$22>1)>=COLUMN(A:I),ROW($1:$18)),ROW(A1)),),"")
留言
張貼留言