Hello there,
Since yesterday I am trying to solve without any success what looked like a simple task in the first place. I have 5 available ports and 5 wires with different colors, which can be inserted to either of the ports. Which wire each port is accepting should looks like this:
<tbody>
</tbody>A valid combination for example will be the following: Port 1 - Green, Port 2 - Red, Port 3 - Black, Port 4 - Grey and Port 5 - White. Overlapping cannot happen, i.e. the following combination is not possible: Port 1 - Red, Port 2 - Red, Port 3 - White, Port 4 - Grey, Port 5 - Black.
I seek a formula (or VBA code), which will list on separate rows all the possible combinations in the way that I wrote it in the valid combination example. I also have MS Access, which I guess can come handy too.
I tried to find a similar thread on the forum but without any success. I guess my lack of explanatory skills in English is giving me a hard time finding the exact keywords to search for.
I will really appreciate your help and I'm sorry if a similar question has been asked and answered before.
Since yesterday I am trying to solve without any success what looked like a simple task in the first place. I have 5 available ports and 5 wires with different colors, which can be inserted to either of the ports. Which wire each port is accepting should looks like this:
Port 1 | Port 2 | Port 3 | Port 4 | Port 5 |
Red | Red | Red | Red | Red |
Green | Green | Green | Green | Green |
White | White | White | White | White |
Black | Black | Black | Black | Black |
Grey | Grey | Grey | Grey | Grey |
<tbody>
</tbody>
I seek a formula (or VBA code), which will list on separate rows all the possible combinations in the way that I wrote it in the valid combination example. I also have MS Access, which I guess can come handy too.
I tried to find a similar thread on the forum but without any success. I guess my lack of explanatory skills in English is giving me a hard time finding the exact keywords to search for.
I will really appreciate your help and I'm sorry if a similar question has been asked and answered before.