J
jamesryan
Hi,
I am trying to create a Playing Card dealing speradsheet. I have it a
the moment where the cell randomly chooses a card numbe
(A,2,3,4,5,6,7,8,9,10,J,Q,K) and then randomly chooses a suit to g
with it (Spades, Hearts, Clubs, Diamonds). The problem i'm having i
like this:
If the first card has already been chosen as say 4 of Clubs, and the
the second card is chosen as a 4, then how do i make sure that Club
isn't chosen as the suit again?
I have managed this bit with the use of the IF function but as it onl
allows 7 nested IF's in one cell i can't use it for the next card an
then the next card.
Any help would be much appreciated.
If you'd like a copy of the spreadsheet to help then email:
(e-mail address removed)
cheer
I am trying to create a Playing Card dealing speradsheet. I have it a
the moment where the cell randomly chooses a card numbe
(A,2,3,4,5,6,7,8,9,10,J,Q,K) and then randomly chooses a suit to g
with it (Spades, Hearts, Clubs, Diamonds). The problem i'm having i
like this:
If the first card has already been chosen as say 4 of Clubs, and the
the second card is chosen as a 4, then how do i make sure that Club
isn't chosen as the suit again?
I have managed this bit with the use of the IF function but as it onl
allows 7 nested IF's in one cell i can't use it for the next card an
then the next card.
Any help would be much appreciated.
If you'd like a copy of the spreadsheet to help then email:
(e-mail address removed)
cheer