I am trying to come up with an easier way to display all possible configurations of various part #s from 6 different columns.
The part #s would all have the data from only 1 cell in each of the columns. They basically look like this:
AAA-111-BBB-222-CCC-333
There are also the following number of possibilities in each column:
A - 1
B - 24
C - 2
D - 6
E - 10
F - 1
I will have to do this for 10 or so other lots that have the same number of possible configurations. I did it manually for the first lot and came up with 122 different configurations for just the first of the 24 possibilities from column B.
If there is a handy way to do this in Excel and you can help explain it, I'd greatly appreciate it!
Thanks for looking.
The part #s would all have the data from only 1 cell in each of the columns. They basically look like this:
AAA-111-BBB-222-CCC-333
There are also the following number of possibilities in each column:
A - 1
B - 24
C - 2
D - 6
E - 10
F - 1
I will have to do this for 10 or so other lots that have the same number of possible configurations. I did it manually for the first lot and came up with 122 different configurations for just the first of the 24 possibilities from column B.
If there is a handy way to do this in Excel and you can help explain it, I'd greatly appreciate it!
Thanks for looking.