Maximum Calculations Of A Data
I am looking for a programmer to Deliver a finished project that shows the combinations that can be made from the numbers 1 through 30. The rules are simple. All values to be comma separated. No duplicates. Order does not matter. I have attached a sample spreadsheet that I have created manually. I am only down to 3 number combinations and I realized that this is something a computer should be able to do faster. I do not want to see one number combinations (ie, a single number by itself) counted as one combination. The combination must be atleast 2 numbers like 2,10. There should be no repeats in any cell. Like 2,2,1,10,12. So each number should only show up one time per cell if applicable. That means we start with:
1,2
1,3
1,4
1,5 all the way to 1,30
then..
2,3
2,4
2,5 all the way to 2,30
After the first number gets all the way to 29,30, we move to three number combination possibilities. Like:
1,2,3
1,2,4
1,2,5
1,2,6 all the way to 1,2,30.
After the three number combination possibilities are done, we go to fours and so on until we get to 15 number combinations and once they are done, we do not go to sixteen. Even though there are 30 numbers to pull from, I do not want to see combinations of more then 15. Attached is a sample spreadsheet that I entered manually to show you the format I want. Pay careful attention to the fact that the pattern is careful to avoid duplicates combinations of any of the cells and duplicate numbers within each individual cell.