Hi everyone,
I am new to this forum and would greatly appreciate your help.
My search on the forum was not successful but if a similar post exists, feel free to direct me.
I need a macro or formula that can produce all possible combinations of 3 from a single column.
I do not need permutation just combination.
Please note: my data set below is just for illustration purposes the number of variables my range from 5 up to 15.
For example:
DATASET: Results:(All combinations of 3 variables)
A..............ABC
B..............ABD
C..............ACD
D..............BCD
E..............BCE (and so on)
your help is very much appreciated, thank you in advance!