Pick 3 excel formula

Reply #7

Raven62 — Wed, 01 Jun 2016 12:09:18 GMT

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

Reply #6

winsumloosesum — Wed, 01 Jun 2016 10:59:56 GMT

Boxed Formula using lowform_3 function.

Google Excel VBA functions

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... [ More ]

Reply #5

adulane62 — Wed, 01 Jun 2016 10:07:14 GMT

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

Reply #4

winsumloosesum — Wed, 01 Jun 2016 09:46:35 GMT

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

Reply #3

CARBOB — Wed, 01 Jun 2016 09:43:09 GMT

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

Reply #2

adulane62 — Wed, 01 Jun 2016 09:39:21 GMT

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.

Reply #1

phileight — Wed, 01 Jun 2016 09:11:05 GMT

in cell a1 0

in cell a2 =a1+1

copy a2 down as needed

If this is not what you wanted, please explain

Pick 3 excel formula

adulane62 — Wed, 01 Jun 2016 07:36:54 GMT

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