Hi there, first post on this forum so basically I have 200 numbers I want too find out what the biggest number I can get with any 100 of them so for example if I had ten numbers:
2
3
4
6
6
7
8
9
1
Id want the biggest number five of them added together is, is there an easy way to do this in excel? For instance in the example the biggest combination of 5 numbers would be 36 however i need to do this on a much larger scale so is there a way to automate it?
Bookmarks