Excel Drawing History

Reply #4

paurths — Mon, 19 Jun 2006 20:27:17 GMT

Reply #3

cps10 — Mon, 19 Jun 2006 18:53:30 GMT

Thanks for all of your help SirMetro and lottaloot.

Reply #2

lottaloot — Mon, 19 Jun 2006 16:43:41 GMT

Cps10, you have a platinum membership, so you ought to be able to obtain that information yourself.

Just go to the individual states that you need save them to notepad.

Once done, go into excel import your external data. (you'll find that under the data tab at the top of excel)

You must make sure that your data is delimited before continuing on.

Pm once you have gotten that far or send me your saved notepad files I will insert them for you.

Reply #1

SirMetro — Mon, 19 Jun 2006 16:40:25 GMT

If your spreadsheet you currently have is set-up something like this

Numabcd

08930893

And you are wanting to break the 4 digits apart, below are the formulas that would be required;

a=SUM(1*(LEFT(C2,1)))

b=SUM(1*(MID(C2,2,1)))

c=SUM(1*(MID(C2,3,1)))

d=SUM(1*(MID(C2,4,1)))

Then, to put the number back together in it's lowest BOX form, use the following code:

=CONCATENATE((SMALL(D2:G2,1)),(SMALL(D2:G2,2)),(SMALL(D2:G2,3)),(SMALL(D2:G2,4)))

The above code assumes a... [ More ]

Excel Drawing History

cps10 — Mon, 19 Jun 2006 16:22:42 GMT

I know everyone is getting sick of this particular request! LOL But...I was wondering if anyone could give me an Draw History for all states for Pick-3 AND Pick-4 whereby the digits are separated by digit? I would only need it from last July (July 2005) till current.

What I mean by separated by digit is to have the first position in one cell, the second position in another cell, and the third position in another cell.

I would certainly appreciate it. One day I will need to just find a way