All combination from several columns

UK_D

New Member
Joined
May 27, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Hi All - New to the site and already after some help!
I'm looking to compile a list of all combinations across 23 columns in excel which I know will be quite a large list.
I've tried to tweak various coding that has been shared on the site but end up with errors (probably because I don't know what I'm doing with the code apart from changing variables to match my columns)

I have the below in excel and want to fetch all the combinations i.e A+A+A..... A+B+A....A+A+B...etc Is this even possible?
Data Set 1Data Set 2Data Set 3Data Set 4Data Set 5Data Set 6Data Set 7Data Set 8Data Set 9Data Set 10Data Set 11Data Set 12Data Set 13Data Set 14Data Set 15Data Set 16Data Set 17Data Set 18Data Set 19Data Set 20Data Set 21Data Set 22Data Set 23
AAAAAAAAAAAAAAAAAAAAAAA
BBBBBBBBBBBBBBBBBBBBBBB
CCCCCCCCCCCCCCCCCCCCCCC
DDDDDDDDDDDDD
EEEEEEEEEE
FFFFFFFFFF
GGGGGGG
HHHHHHH
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

JamesCanale

Active Member
Joined
Jan 13, 2021
Messages
289
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
10^15 combinations. Too much to handle and it'll take too long to calculate in excel.
 

Forum statistics

Threads
1,141,130
Messages
5,704,452
Members
421,350
Latest member
jake9951

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
Top