Excel Help

[SeaPanda]

What's up guys, I'm not sure this is the right place to ask this but I'm going to give it a shot anyway. I'm trying to figure out how to make combinations using this data set: 34, 23, 299, 15, 7, 32, 45, 50, 13, 7 . The combination has to be 10 choose 8 so there is 45 combinations in total. Is there a function in excel that can help with this? 

[Alaa]

11 minutes ago, Sebastian Kurpiel said:

What's up guys, I'm not sure this is the right place to ask this but I'm going to give it a shot anyway. I'm trying to figure out how to make combinations using this data set: 34, 23, 299, 15, 7, 32, 45, 50, 13, 7 . The combination has to be 10 choose 8 so there is 45 combinations in total. Is there a function in excel that can help with this? 

Can you translate that into a math equation or rephrase, not sure I understand

[SeaPanda]

1 minute ago, Alaa said:

Can you translate that into a math equation or rephrase, not sure I understand

So I have to create 8 number combinations without repetition using the 10 number data set above. So like 34,23,299,15,7,32,45,50 as the first combination, repeat 44 times. As you can guess this gets complicated fast and I thought excel might have a function built in to slove this.

[Alaa]

4 minutes ago, Sebastian Kurpiel said:

So I have to create 8 number combinations without repetition using the 10 number data set above. So like 34,23,299,15,7,32,45,50 as the first combination, repeat 44 times. As you can guess this gets complicated fast and I thought excel might have a function built in to slove this.

I don't think there is, unless you can translate that into an equation

[Mira Yurizaki]

https://www.extendoffice.com/documents/excel/3097-excel-list-all-possible-combinations.html

 

I found that. Good luck :3

[Alaa]

14 minutes ago, M.Yurizaki said:

https://www.extendoffice.com/documents/excel/3097-excel-list-all-possible-combinations.html

 

I found that. Good luck :3

I suck at office work