I have a competition team with 8 members. Each member is assigned a skill level between 2 and 7. I would like excel to generate all unique combinations of 5 team members whose skill level in total is 23 or less.
I have a competition team with 8 members. Each member is assigned a skill level between 2 and 7. I would like excel to generate all unique combinations of 5 team members whose skill level in total is 23 or less.
Hi tonynap,
Welcome to the forum.
Suggest you to upload a sample workbook for forum members to understand better your query. thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks