how do i create all possible combinations from a set of nos. in ex
 

i have to map out all possible combinations for a lottery from a range of 1-4
in excel and i can't find the formula in the Excel help file. can anyone
shed some light on this. it is for a school project in statistics.

how do i create all possible combinations from a set of nos. in ex
 

Sounds like you want to determine the number of combinations of r objects
from n objects. I suspect there isn't a "formula" in excel to give you the
combinations, but depending on how many combinations you could possibly have,
might take a while.
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"Combination Confusion" wrote:

i have to map out all possible combinations for a lottery from a range of 1-4
in excel and i can't find the formula in the Excel help file. can anyone
shed some light on this. it is for a school project in statistics.

how do i create all possible combinations from a set of nos. in ex
 

When you say "Map out" do you mean that you want to display all the
combinations or do you want to simply know how many combinations?

To display all the numbers it could probably be done with a macro but you
need to realize that there is a limit on the number of rows. I don't
understand what you mean by "a range of 1-4".

How many numbers is there to select from?
How many does the player select?

However, if you just the total combinations then see COMBIN function in help.


--
Regards,

OssieMac


"Combination Confusion" wrote:

i have to map out all possible combinations for a lottery from a range of 1-4
in excel and i can't find the formula in the Excel help file. can anyone
shed some light on this. it is for a school project in statistics.