I have 5 categories and 6 subjects and I need to arrange them such that for 59 rows, each row has a 1 subject in one of the categories, with one repeat. The tricky part is that they need to be in each category a certain total percentage (repeats column is how many times each subject is in a category to make that % work for 59 rows) :
Category Repeats % Breakdown
1 6 10
2 17 30
3 18 30
4 12 20
5 6 10
How can I do this quickly in excel without just guess and check endlessly?
Bookmarks