=IF(MAX(FREQUENCY(IF(A1:Z1=9,COLUMN(A1:Z1)),IF(A1:Z1<>9,COLUMN(A1:Z1))))>5,"連續出現次數已達五次","") 貼上公式後按Ctrl+Shift+Enter (正確的話公式兩旁會出現{ } ...
確定! 回上一頁