Thread: How to get all the possible 6 number combinations from numbers 1-36
View Single Post
  #2   Report Post  
Spencer101 Spencer101 is offline
Senior Member
  
Posts: 663
Default
Quote:
Originally Posted by Ms Nosizwe View Post
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()
Reply With QuoteReply With Quote