Hi,
I would like to make all 6-digit combinations possible from the numbers in column A.
And i also would like to add/sum each combination if possible.
See attachment
Hi,
I would like to make all 6-digit combinations possible from the numbers in column A.
And i also would like to add/sum each combination if possible.
See attachment
Hi.
Do you realise that the number of different combinations of 6 numbers from the 990 you have in column A is more than 1 quadrillion, i.e.:
1,287,912,126,756,260
which would require more than 1 million columns to be fully populated in a standard Excel 2010 sheet, which would require just under 75,000 worksheets with every single cell fully populated?
Good luck!!
Regards
You are wright.
I made a mistake. In the next example I have a square which represent all the combinations from the number 1 to 45, 8 million give or take.
I would like to sum all these possible 6-digit combination.
So say i have the combination 1-2-3-4-5-6 and this would add up to: (0.89+0.28+0.96+-1.5+-2.5) +(2.03+3.13+2.32+1.56)+(1.68+3,23+-2)+(-2.6+0.27)+(-2.1)
I made it yellow in the attachment
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks