View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default How to get all the possible 6 number combinations from numbers 1-36

After serious thinking Spencer101 wrote :
Ms Nosizwe;1607415 Wrote:
how can i work out all the possible 6 number combinations from 1-36
(similar to a lottery ticket - pick 6 from 36).


Look up how to use =PERMUT()


This will return the total number of possible combinations, NOT the
actual combinations.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion