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? 

[steffen_anywhere]

21 hours 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? 

There isn't an easy function to do that... you can copy your data set a few times and then write a function for one of the variations. Time consuming but should work. Excel doesn't do vectors as it's a spreadsheet program. You could use MATLAB or Octave to do this easily.