LinkBack URL
About LinkBacks
So have your ranges changed to I5:I9, K5:K9, I12:I16, K12:K16?
I don't see where you tried the formula?
So have your ranges changed to I5:I9, K5:K9, I12:I16, K12:K16?
I don't see where you tried the formula?
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Maybe...
=SUMPRODUCT(COUNTIF(INDIRECT({"I492:I496","I499:I503","K492:K496","K499:K503"}),X1))
Hope it helps!
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.
To VANE0326: thanks for the info, but according to Excel and I quote: "You may not use unions, intersections, or arrey constants for Data Validation or Conditional Formats" unquote. So, I'm back at the same point, not that it matters much, my last 2 hairs fell out last night, so I guess I'll have to try it from another direction.
Thanks for all the info and I'll keep looking.
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.
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....
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.
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?
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks