求教怎樣用EXCEL計算彩票的單雙遺漏？

當前遺漏=RIGHT(MAX(IF(ISERROR(FREQUENCY(IF(C1:C11=C11,ROW(1:11)),IF(C1:C11<>C11,ROW(1:11)))+ROW(1:11)*100),0,FREQUENCY(IF(C1:C11=C11,ROW(1:11)),IF(C1:C11<>C11,ROW(1:11)))+ROW(1:11)*100)),2)*1數組公式，請同時按下Ctrl+Shift+Enter三鍵結束最大遺漏=MAX(FREQUENCY(IF(C1:C11="單",ROW(1:11)),IF(C1:C11<>"單",ROW(1:11))),FREQUENCY(IF(C1:C11="雙",ROW(1:11)),IF(C1:C11<>"雙",ROW(1:11))))數組公式，請同時按下Ctrl+Shift+Enter三鍵結束如果表格不是舉例一樣行列數，公式得修改