Need an Excel/Google Sheet Formula for PermuationPrev TopicNext Topic

• ScreamingMidget

  

  Florida
  United States
  Member #126,768
  April 16, 2012
  1,872 Posts
  Offline
  Jan 22, 2018, 12:48 am

  ▲▼

  Hey guys. I was wondering if someone knew how to do this in excel. 

   

  I was reading an old thread: https://www.lotterypost.com/thread/268170/3335045

   

  So what I was wondering was how can I put in the formula to calculate

  or put in the permutation to an adjacent cell.

   

  Example:

   

  Draw    Permutation

  907      312 

  567      123

  415      213

   

  Etc etc.

   

  I have my draws set up to where each digit is in it's own cell.

   

  So Exampe: A1:9  A2:0  A3:7.

   

  Then Cell A4: formula to calculate permuation.

   

   

  Thanks!
• CARBOB

  

  COLUMBUS,GA.
  United States
  Member #4,924
  June 3, 2004
  6,719 Posts
  Offline
  Jan 25, 2018, 6:14 am

  ▲▼

  Ctrl-Alt-Enter

  =SUMPRODUCT(MMULT((MID($D3,{1;2;3},1)>MID($D3,{1,2,3},1))+0,{1;1;1})+1,10^{2;1;0})
• ScreamingMidget

  

  Florida
  United States
  Member #126,768
  April 16, 2012
  1,872 Posts
  Offline
  Jan 25, 2018, 6:16 pm

  ▲▼
  In response to CARBOB

  Quote: Originally posted by CARBOB on Jan 25, 2018

  Ctrl-Alt-Enter

  =SUMPRODUCT(MMULT((MID($D3,{1;2;3},1)>MID($D3,{1,2,3},1))+0,{1;1;1})+1,10^{2;1;0})

  Thanks CARBOB!