E6:E15{=INDEX(C:C,SMALL(IF(C$5:C$15<>C$6:C$16,ROW($6:$16),99),ROW(A1)))&""
F6:G15{=IF($E6="","",TEXT(INDEX(FREQUENCY(ROW($6:$16),IF($C$5:$C$15<>$C$6:$C$16,ROW($6:$16))),ROW(A2)),IF(B$5=$B$5,"[>1]!*;","[>1]0;")))
I6:I15=IF((E6="")+(ROW(A1)=1),"","+")&E6&F6&G6&I7
留言
張貼留言