countif on nonconnected ranges

**NBVC** · 05-15-2007, 07:54 AM

Originally Posted by village_idiot

To NBVC: the addresses has changed, because the work sheet I was working from has a lot of other info that I garnered from this fantastic web site and it's even more fantastic people who take the time to help me and my fellow noobs.

I cut and pasted only the one item to work on. I tried your formula and since it didn't do anything I removed it.

If you specify exactly what you are doing and what results you expect and where you expect them, referencing the cells in the sheet you attached, I am sure we can come up with a solution....

**village_idiot** · 05-15-2007, 11:27 AM

What I want to do is to let the 4 player H5:H9, H12:H16, J5:J9 and J12:J16 draw new cards using I5:I9, I12:I16, K5:K9 and K12:K16 without any two people picking the same card. It's not real earth shattering I know, but I got it in my head and it lonely in there for it so I have to get the answer so it can leave.

**NBVC** · 05-15-2007, 11:58 AM

Maybe you want data Validation from the Data menu.

This will pop up a message if someone tries entering a card that has already been selected in any of the 4 hands.

See attached try entering the same number in any 2 boxes.

Is this what you desire?

**village_idiot** · 05-15-2007, 12:34 PM

I tried like you said and nothing happened, the only difference I could see is that there was a conditional format, that also didn't work. What I want to figure out is the proper way to use the data validation on the 4 different ranges, if they aren't connected.

**NBVC** · 05-15-2007, 12:48 PM

I must have not saved it after I did the DV stuff...

Try again with the attached.

**village_idiot** · 05-15-2007, 01:01 PM

Bingo, just what the doctor ordered. Thanks much and now after work I'll have to dissect your work to see were I messed up. Again thanks to everyone for your help.