# 6-digit combinations of numbers column A

1. ## 6-digit combinations of numbers column A

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

2. ## Re: 6-digit combinations of numbers column A

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

3. ## Re: 6-digit combinations of numbers column A

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

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1