View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default 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.