Hello. As you can see I am new to this forum. I hope someone can help me with my problem. I'll try to explain the data I am using and what I need, although it's a bit difficult to explain. Especially since I do not use Excel very often. This is what I have:
Each person always gets 5 checks/trues (or a '1' in this case) out of 20, I need to find which 4 people will make a full row of 20 true's, and if that combination doesn't exist, which 5 people. It would be great if it could show multiple combinations, first the 4 people combinations, then the 5, etc. But just the 4 people combination is sufficient.Please Login or Register to view this content.
I hope someone understands what I need and hopefully someone knows how to get it. Thanks in advance!
Bookmarks