How to list all combinations from 6 rows

bvbull200

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

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
Edit: Thread title says 6 rows, but I meant 6 columns as detailed in the post. Sorry for the confusion.
 
Upvote 0

Forum statistics

Threads
1,213,567
Messages
6,114,344
Members
448,570
Latest member
rik81h

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top