• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

how to get all possible combinations from six columns

Hi all,

I have a sheet with six columns of data

I want to try and list all the possible combinations, using information from each of the six columns

I've attached a sample sheet so you can see what I mean,

I want to list all combinations in column J

Many thanks

Brian
 

Attachments

  • Book2.xlsx
    9.9 KB · Views: 14
Hi all,

I have a sheet with six columns of data

I want to try and list all the possible combinations, using information from each of the six columns

I've attached a sample sheet so you can see what I mean,

I want to list all combinations in column J

Many thanks

Brian
Hello Brian,
Please check the file what you look for?!
Regards
Thangavel D
 

Attachments

  • Book2.xlsx
    476.9 KB · Views: 12
Hello Brian,
Please check the file what you look for?!
Regards
Thangavel D
Hi ,

Please check your file.

The total number of rows in the combinations output table should be :

21 * 2 * 6 * 4 * 4 * 4 = 16128

There are an extra 2688 rows which are a result of including the header label colour in column 3.

Narayan
 
Hi ,

Please check your file.

The total number of rows in the combinations output table should be :

21 * 2 * 6 * 4 * 4 * 4 = 16128

There are an extra 2688 rows which are a result of including the header label colour in column 3.

Narayan
Hello Narayan,
I used MS query in excel to get the combinations. I'm getting 78 extra i.e 16206. Can you please check the attached file.
Regards,
Thangavel D
 

Attachments

  • Book2.xlsx
    78.9 KB · Views: 8
Hello Narayan,
I used MS query in excel to get the combinations. I'm getting 78 extra i.e 16206. Can you please check the attached file.
Regards,
Thangavel D
Hi ,

Now the problem is different ; if you see your file , the table headers are the items themselves ; this means that instead of getting 16128 , which is :

=21 * 2 * 6 * 4 * 4 * 4

the table is having only 2700 items , which is :

=20 * 1 * 5 * 3 * 3 * 3


Narayan
 
Back
Top