Good day all!
My question is sort of a Math/Computer question.... If you could just tell me the Math process I should follow to reach the answer, I will make the program.
There is an Array named C contains 100 different numbers :
For Example:
C(1) = 142
C(2) = 876
C(3) = 64
...
C(100) = 7124
I want to calculate how many possible combinations we can have contains 10 Numbers (out of those 100 numbers).
For Example:
Lets have a look at a smaller example. If array C contains 5 digits as follows:
C(1) = A
C(2) = B
C(3) = C
C(4) = D
C(5) = E
How many Cmbination of 3 Digits we can have ?
Answer:
ABC / ABD / ABE / ACD / ACE / ADE / BCD / BCE / CDE / BDE .. ?
But what is the process for finding above combinations I don't know!
Hope my question is clear? I appreciate if anyone could help me find the formula .
My final aim is to use this formula for a program in Excel (VBScript).
Take care all! thanks for reading :wink:
My question is sort of a Math/Computer question.... If you could just tell me the Math process I should follow to reach the answer, I will make the program.
There is an Array named C contains 100 different numbers :
For Example:
C(1) = 142
C(2) = 876
C(3) = 64
...
C(100) = 7124
I want to calculate how many possible combinations we can have contains 10 Numbers (out of those 100 numbers).
For Example:
Lets have a look at a smaller example. If array C contains 5 digits as follows:
C(1) = A
C(2) = B
C(3) = C
C(4) = D
C(5) = E
How many Cmbination of 3 Digits we can have ?
Answer:
ABC / ABD / ABE / ACD / ACE / ADE / BCD / BCE / CDE / BDE .. ?
But what is the process for finding above combinations I don't know!
Hope my question is clear? I appreciate if anyone could help me find the formula .
My final aim is to use this formula for a program in Excel (VBScript).
Take care all! thanks for reading :wink: