H4L11{=IF(MOD(ROW(A1),7)=1,SMALL(IF((COUNTIF($G4:G4,ROW($1:$52))=0)*(COUNTIF($H$3:$L3,ROW($1:$52))=0),ROW($1:$52)),RANDBETWEEN(1,52-COLUMN(A1)-(ROW(A1)>1)*5)),"")
B4:F4=LOOKUP(MOD(H4-1,13)+1,ROW($1:$13),{"A";2;3;4;5;6;7;8;9;10;"J";"Q";"K"})
B11:F11=LOOKUP(MOD(H11-1,13)+1,ROW($1:$13),{"A";2;3;4;5;6;7;8;9;10;"J";"Q";"K"})
B3:F3 (複製到 B5:F5)=LOOKUP(H$4,{1,27,40},{"●","◆","★"})
B10:F10 (複製到 B12:F12)=LOOKUP(H$11,{1,27,40},{"●","◆","★"})
B3:F5 格式化=MOD(INT((H$4-1)/13)+1,2)
B10:F12 格式化=MOD(INT((H$11-1)/13)+1,2)
N7{=AND(COUNTIF(H:M,IF({1;0},H4:L4,H11:L11))=1)
更正截圖 ★ 代表黑梅
留言
張貼留言