What im trying to accomplish is this, We have 12 kids and and 6 Families. I want to be able to assign the kids to each family in a way they will not duplicate more than once for anyone family and the family ends with three kids to give presets to(not their own kids). Each family needs to be assigned three kids non of which can be duplicate for that family. Trying to make random lottery style sheet for giving kids presents. Guys i know this sounds crazy. I may be over complicating this, but I know there has to be a way. I have been messing around with the Rand function in excel, (and maybe this is more of an access goal), but if you could set up the randbetween function to not equal itself in another cell this could work possibly. But I haven't figured this out.
Screenshot 2014-11-23 19.22.35.jpg
Bookmarks