I am working with a table of numbers (and some empty cells), and I would like for Excel to choose the best set of numbers for my problem.
-I can only have one chosen number per row and column.
-The sum of the chosen numbers must be the minimum possible.
-Excel needs to list which numbers should be chosen (either highlighted, listed, etc.)
The tables I will be using will vary in the number of rows and columns, but for the sake of simplicity I have attached a sample table. For what it's worth, the real tables will be much larger than this sample. The cells highlighted are the ones that I want Excel to be able to pick out as the best solution (since only one cell is chosen per row and column, and the sum of these values is the lowest possible of all combinations).
I hope I have been clear in what I am looking to do. If not, feel free to ask questions. I appreciate any help that can be provided!
Bookmarks