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.
|