Welcome Guest
You last visited April 30, 2017, 12:43 pm
All times shown are
Eastern Time (GMT-5:00)

Pick 3 excel formula

Topic closed. 7 replies. Last post 11 months ago by Raven62.

 Page 1 of 1
From Denver, Rocky Mountain Empire,
United States
Member #49750
February 13, 2007
499 Posts
Offline
 Posted: June 1, 2016, 3:36 am - IP Logged

Anyone know the whole 1000 Pick 3 excel formula for singles, doubles, and triples...don't wanna put 'em one at a time! Thanks!

Go Broncos!

United States
Member #41846
June 23, 2006
462 Posts
Offline
 Posted: June 1, 2016, 5:11 am - IP Logged

in cell a1    0

in cell a2    =a1+1

copy a2 down as needed

If this is not what you wanted, please explain

From Denver, Rocky Mountain Empire,
United States
Member #49750
February 13, 2007
499 Posts
Offline
 Posted: June 1, 2016, 5:39 am - IP Logged

phileight,

Thanks for your help! However, that is not what I'm looking for...I have downloaded all 1000 numbers, I just need a formula that shows singles as "S", doubles as "D", etc...Thanks.

Go Broncos!

ORLANDO, FLORIDA
United States
Member #4924
June 3, 2004
6065 Posts
Online
 Posted: June 1, 2016, 5:43 am - IP Logged

Anyone know the whole 1000 Pick 3 excel formula for singles, doubles, and triples...don't wanna put 'em one at a time! Thanks!

All 3 digits must be in one cell.

SHIFT-CTRL-ENTER

=IF(OR(AND(ISNUMBER(MATCH({0,1,9},MID(\$K680,{1,2,3},1)+0,0))),AND(ISNUMBER(MATCH(MIN(MID(\$K680,{1,2,3},1)+0)+{0,1,2},MID(\$K680,{1,2,3},1)+0,0)))),"C",INDEX({"S","D","T"},MAX(FREQUENCY(MID(\$K680,{1,2,3},1)+0,MID(\$K680,{1,2,3},1)+0))))

Play 4 same way

{1,2,3,4},1)+0)+{0,1,2,3},MID(\$V1,{1,2,3,4},1)+0,0)))),"C",IF(SUM(IF(FREQUENCY(MID(\$V1,{1,2,3,4},1)+0,MID(\$V1,{1,2,3,4},1)+0)=2,1))=2,"DD",INDEX({"S","D","T","Q"},MAX(FREQUENCY(MID(\$V1,{1,2,3,4},1)+0,MID(\$V1,{1,2,3,4},1)+0)))))

Pennsylvania
United States
Member #2218
September 1, 2003
5464 Posts
Online
 Posted: June 1, 2016, 5:46 am - IP Logged

A1 = Pick 3 Number. Example 123

B1 = Value(mid(text(\$A1,"000"),1,1))

C1 = Value(mid(text(\$A1,"000"),2,1))

D1 = Value(mid(text(\$A1,"000"),3,1))

Cell E1 enter the following formula:

=CHOOSE(MAX(INDEX(COUNTIF(\$B1:\$D1,\$B1:\$D1),)),"S","D","T"))

From Denver, Rocky Mountain Empire,
United States
Member #49750
February 13, 2007
499 Posts
Offline
 Posted: June 1, 2016, 6:07 am - IP Logged

Works like a charm! Thank you carbob and winsum! and phileight too!

Go Broncos!

Pennsylvania
United States
Member #2218
September 1, 2003
5464 Posts
Online
 Posted: June 1, 2016, 6:59 am - IP Logged

Boxed Formula using lowform_3 function.

Enter your Pick 3 number in cell A1

Enter the following formula in cell F1

=lowform_3(A1)

This will give you the "box" set from cell A1

You will need to know how to add this code below to a new module before using it.

Not sure who posted the code below here at LP.  Not mine.

Function lowform_3(three_digit)
Dim channel() As Integer
Dim slot() As Integer
Dim num As Integer, pos As Integer
Dim c0, c1, c2, c3

c0 = three_digit
c1 = Int(c0 / 100)
c2 = Int((c0 Mod 100) / 10)
c3 = c0 Mod 10
ReDim channel(9)
ReDim slot(3)
channel(c1) = channel(c1) + 1
channel(c2) = channel(c2) + 1
channel(c3) = channel(c3) + 1
pos = 1
For num = 0 To 9
While channel(num) > 0
slot(pos) = num
channel(num) = channel(num) - 1
pos = pos + 1
Wend
Next num
lowform_3 = slot(1) * 100 + slot(2) * 10 + slot(3)
End Function

New Jersey
United States
Member #17843
June 28, 2005
56340 Posts
Offline
 Posted: June 1, 2016, 8:09 am - IP Logged

Anyone know the whole 1000 Pick 3 excel formula for singles, doubles, and triples...don't wanna put 'em one at a time! Thanks!

https://www.lotterypost.com/charts/pick3/combinations

A mind once stretched by a new idea never returns to its original dimensions!

 Page 1 of 1