合併格 底下非空彙整 (13744)

L3:O10{=INDIRECT(TEXT(SMALL(IF((LOOKUP(COLUMN($A:$J),COLUMN($A:$J)/($A$2:$J$2<>""),$A$2:$J$2)=L$2)*($A$3:$J$5<>""),{3;4;5}/1%+COLUMN($A:$J),999),ROW(A1)),"!R0C00"),)&""




留言