Hello!
I am trying to determine the shortest flow path for a list of routings, the flow has to go through all six each time. I am trying to determine a way to calculate/display all 6! (720 combinations) of the route. The different stages are 1-2-3-4-5-6.
I need a way for excel to display all possible combinations (134562,154362,etc)
Is there a way to do this?
See attached.
Contains a VBA routine for calculating permutations/combinations.
MM
Its not combination your looking for its permutation.
Ill be interested to see if one of the gurus can resolve this, best of luck
Beyond simply generating combinations/permutations, it sounds more like the well known "shortest path" problem (Curiously, someone else just asked a different shortest path problem). I put "excel shortest path problem" into my favorite internet search engine and found many tutorials and discussions about this common problem. This was just the first on the list: http://www.excel-easy.com/examples/s...h-problem.html
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks