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?
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 1 | Data Set 2 | Data Set 3 | Data Set 4 | Data Set 5 | Data Set 6 | Data Set 7 | Data Set 8 | Data Set 9 | Data Set 10 | Data Set 11 | Data Set 12 | Data Set 13 | Data Set 14 | Data Set 15 | Data Set 16 | Data Set 17 | Data Set 18 | Data Set 19 | Data Set 20 | Data Set 21 | Data Set 22 | Data Set 23 |
A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A |
B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B |
C | C | C | C | C | C | C | C | C | C | C | C | C | C | C | C | C | C | C | C | C | C | C |
D | D | D | D | D | D | D | D | D | D | D | D | D | ||||||||||
E | E | E | E | E | E | E | E | E | E | |||||||||||||
F | F | F | F | F | F | F | F | F | F | |||||||||||||
G | G | G | G | G | G | G | ||||||||||||||||
H | H | H | H | H | H | H |