樸克牌 發4家牌 (13593)

G2:J14=RAND()

B2:E14=LOOKUP(MOD(RANK(G2,$G:$J)-1,13)+1,ROW($1:$13),{"A";2;3;4;5;6;7;8;9;10;"J";"Q";"K"})&"  "&LOOKUP(RANK(G2,$G:$J),{1,27,40},{"●","◆","★"})

B2:E14 (紅磚 紅桃格式化)=MOD(INT((RANK(G2,$G:$J)-1)/13)+1,2)

B2:E14 (黑梅格式化)=FIND("★",B2)

L2=AND(COUNTIF(B:E,{"A";2;3;4;5;6;7;8;9;10;"J";"Q";"K"}&"  "&"★")=1)