Hello -
I am trying to get excel to generate a list of all possible combinations of 3 from a single column of data. I have searched a lot online for this and see a number of options of creating unique combinations when looking at more than one column of data but what I am trying to do is look at a single column and just specify the number of elements I am looking to combine.
For example I have a column of data as such:
Column A:
Product 1
Product 2
Product 3
Product 4
What i am looking for excel to generate is a list of all combinations of 3 products. So the result would look like this:
Column B:
Product 1, Product 2, Product 3
Product 1, Product 2, Product 4
Product 1, Product 3, Product 4
Ideally the number of elements I am looking to combine would be a variable so if I had a list of 100 products I could then update the formula to give me a list of all combinations of 4 products or 5 products etc.
Does anyone know a formula (no VBA as i need to put this in google sheets) that I can use for this? I will do the research just not sure where to start as everything I see refers to combining different rows of data.
Thanks so much in advance!
I am trying to get excel to generate a list of all possible combinations of 3 from a single column of data. I have searched a lot online for this and see a number of options of creating unique combinations when looking at more than one column of data but what I am trying to do is look at a single column and just specify the number of elements I am looking to combine.
For example I have a column of data as such:
Column A:
Product 1
Product 2
Product 3
Product 4
What i am looking for excel to generate is a list of all combinations of 3 products. So the result would look like this:
Column B:
Product 1, Product 2, Product 3
Product 1, Product 2, Product 4
Product 1, Product 3, Product 4
Ideally the number of elements I am looking to combine would be a variable so if I had a list of 100 products I could then update the formula to give me a list of all combinations of 4 products or 5 products etc.
Does anyone know a formula (no VBA as i need to put this in google sheets) that I can use for this? I will do the research just not sure where to start as everything I see refers to combining different rows of data.
Thanks so much in advance!