How to list all combinations from 6 rows

bvbull200

New Member
Joined
Jul 29, 2013
Messages
23
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.
 

bvbull200

New Member
Joined
Jul 29, 2013
Messages
23
Edit: Thread title says 6 rows, but I meant 6 columns as detailed in the post. Sorry for the confusion.
 

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,721
Office Version
2010
Platform
Windows
You're welcome.
 

Forum statistics

Threads
1,084,861
Messages
5,380,352
Members
401,666
Latest member
ddekort

Some videos you may like

This Week's Hot Topics

Top