Evaluate Multiple Scenarios

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • I may not be stating what I want to do properly, and that is why I cannot find an existing thread to help me out here. I have a simple table. Y represents a current running item, X is the next item to use/run. It takes different amount of times to go from one to the other. I am using an "INDEX" formula to see the times. By taking the items and rearranging them, I can get a shorter time to run everything (Scenario A vs Scenario B in my sheet). Is there a way with VBA to evaluate every possible scenario and find the best arrangement with the shortest total time?

    I have attached an example. I am not asking anyone to write a code for me just point in the right direction, or better yet, an existing thread on here that might help me out.

    Please and Thank you

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!