樸克牌 隨機發四家排 (14609)

G2:J14=RAND()

B2:E14=SUBSTITUTE(MID("A23456789ZJQK",MOD(RANK(G2,$G:$J)-1,13)+1,1),"Z",10)&" "&MID("♠♦♣♥",INT((RANK(G2,$G:$J)-1)/13)+1,1)

B2:E14格式化=(RIGHT(B2)="♦")+(RIGHT(B2)="♥")

M2=COUNTIF(B:E,"*"&L2)

P2=COUNTIF(B:E,O2&"*")