Simple Combination in Excel

Reply #8

Raven62 — Sat, 18 Jun 2011 20:14:19 GMT

Excel formulas for converting Pick 3 to Pairs

Assuming Cell B2 is where you enter the 3 digit combo:

Cell D: =QUOTIENT(B2/10)

Cell E: =QUOTIENT(B2,100)*10+MOD(B2,10)

Cell F: =MOD(B2,100)

(I have draw date and draw number in columns A and B

Reply #7

Seachelle — Thu, 16 Jun 2011 18:00:56 GMT

Thanks Everyone for the Help

Reply #6

paradisenow — Wed, 15 Jun 2011 12:14:08 GMT

thanks for posting

Reply #5

SteveC — Wed, 15 Jun 2011 11:51:06 GMT

Thanks Raven.

I was hoping to find some way to take three digits and break them down into three sets of two.

Anyone have any ideas on that

Reply #4

Raven62 — Tue, 14 Jun 2011 20:38:12 GMT

=A1*100+B1*10+C1*1

The term is: Positional Wheel!

An alternative to using Excel is Paurth's Pick 3 Wheel Engine:

http://members.lotterypost.com/paurths

Reply #3

time*treat — Tue, 14 Jun 2011 07:51:54 GMT

One way to do this is the CONCATENATE function. Here's an example.

https://www.lotterypost.com/thread/159272

Reply #2

Seachelle — Mon, 13 Jun 2011 22:44:29 GMT

Thanks Grwurston

I'll give it a try

Reply #1

grwurston — Mon, 13 Jun 2011 22:23:46 GMT

Hi Seachelle,

There's no need to go to excel, just do an LP search for paurths hot cold counter. You can enter your drawn #s, check off whatever #'s you want in each column and it will give you all the possible combinations, for singles, doubles, triples.

I use it all the time, I even have it in my task bar. LOL. Good Luck

Simple Combination in Excel

Seachelle — Mon, 13 Jun 2011 21:53:16 GMT

Hi Everyone,

I'm looking for a simple excel formula in excel to make combinations from different columns. I've used the search tool (combination, combinations VBA, column combinations, etc..). Its probably one out there thats exactly what I want but I can't find the correct wording to pull it up. I tried adapting some of the ones I did find but failed. So here is what I'm looking for

example

Column A has 3 digits, Column B has 2 digits and Column C has 4 digits.

Combinations... [ More ]