合併格項目 改變排列次序 (14444)

I2:M13{=INDEX(LOOKUP(ROW(2:13),ROW(2:13)/(A$2:A$13<>""),A$2:A$13),RIGHT(SMALL(MATCH(LOOKUP(ROW(2:13),ROW(2:13)/($A$2:$A$13<>""),$A$2:$A$13),$G:$G,)/1%+ROW($1:$12),ROW(A1)),2))



留言