At the moment I have a workbook which tests if, for a number of selections of 4 options (out of 21), they can be selected from a table of 4 columns which contain all 21 options spread throughout the 4 columns and possibly appearing in more than one column each, with one of the selections coming from each of the four columns. I can then see if the selections chosen are accommodated by the spread of options in the table. What I want to be able to do is, rather than put the options spread into the table, get excel to test all possible spreads of options and come up with the spread which fits the selections best. So effectively I would need a macro which can create the table and test it as my sheet does at the moment and come out with a % fit and then change the table and do this for all the possible spreads and come out with a list of %s to show the best fits. I can then hopefully work out a way to click on each of the possible spreads or % and it will show me what table it created for that. If anyone understands my ramblings, do you think this is possible to do? I have attached a simple sample sheet to try and show what I am talking about.
Many thanks and any comments or ideas would be great fully received,
Jack
Bookmarks