you know, you would not need to input 63 different scenarios into your model. just 9 for the column and 7 for the headers BUT you wouldn't use the scenario manager, you would use data validation or a combobox for each of the variable. of course, you would need to explore all 63 combinations if you felt the need to do that. in summary, five minutes rather two hours to set up.
@joshg2538
2 жыл бұрын
Great video. Any idea what would cause the answers to be off by one column?
@MrXL
2 жыл бұрын
That is a strange one. I am trying to create a model where this happens and I can't. If you still haven't figured it out, you might create a new thread at MrExcel Message Board and post a screenshot of your model. www.mrexcel.com/board/forums/excel-questions.10/
@zaighamuddinfarooqui1705
7 жыл бұрын
Wonderful :)
@evilangel4136
2 жыл бұрын
can we use 3 or more variable using concat the parameter/variable using delimiter in one column then use data table to compute the value? Like : Principal-Term-Rate 20000-60-3% 20000-60-4% 20000-60-5% 20000-120-3% 20000-120-4% 20000-120-5% ... Split the cell into cell B1 to B3..
@MrXL
2 жыл бұрын
Great idea. That should work perfectly.
@kapamagicman
8 жыл бұрын
👍
@BestICan
8 жыл бұрын
Bill, my challenge seems to be the inverse of a Data Table. I want Excel to calculate how many arrows I can build that weigh exactly the same, given a table of four different components (field tip, ferrule, nock, shaft weight), many of which have differing weights. I have twelve arrows to build, so there's forty-eight instances of components in the table. I'm stumped. Obviously, it needs to iterate through the table looking to mix-n-match components until it finds the greatest number of matches that have a common weight. So, I need to create that formula, AND, create a table of the matches as a guide so I can pull the matching components from their respective bins that are sorted by weight. Make sense? Ideas? Thank you!
@BestICan
8 жыл бұрын
Bill, thank you! I'll dig in and see if I can craft a solution from your recommendations.
Пікірлер: 13