https://www.lotterypost.com/thread/318007 Lottery Post Forum Topic: Need an Excel/Google Sheet Formula for Permuation en-us Lottery Post RSS Generator https://www.lotterypost.com/thread/318007/5415879 https://www.lotterypost.com/thread/318007/5415879 Thu, 25 Jan 2018 23:16:35 GMT ScreamingMidget Thanks CARBOB

]]> ScreamingMidget https://www.lotterypost.com/thread/318007/5415123 https://www.lotterypost.com/thread/318007/5415123 Thu, 25 Jan 2018 11:14:05 GMT CARBOB 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

]]> CARBOB https://www.lotterypost.com/thread/318007 https://www.lotterypost.com/thread/318007 Mon, 22 Jan 2018 05:48:41 GMT ScreamingMidget 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... [ More ]

]]> ScreamingMidget