Need help with Excel

Reply #5

Neener — Wed, 24 Dec 2014 14:07:18 GMT

Thank you Steve.

Merry Christmas

Neener

Reply #4

winsumloosesum — Wed, 24 Dec 2014 00:19:12 GMT

Your welcome!!

These 2 Excel files include all states draws.

https://app.box.com/s/wbi688upw1ewcwxymnpp

https://app.box.com/s/hxdykstj1nz78mfi1h7c

I post a video later on how to use the Excel files.

Reply #3

theo1946 — Tue, 23 Dec 2014 23:49:32 GMT

Hi win,

Thank you, exactly what I had in mind.

Merry Christmas,

Ted

Reply #2

winsumloosesum — Tue, 23 Dec 2014 22:57:26 GMT

California Combined Draws

Tab = CA3C

Updated the Midday drawing 9-8-1 by clicking the toolbar Add New Drawing

Entered 981 in cell F20

Total Draws Used = 6183 (Cell X3)

Last Draw Midday 12/23/2014 9-8-1

Select 9 cell H14

Select 8 cell K14

Select 1 cell N14

Top Digits - Note: Numbers in parenthesis are the total number of hits

(9) Top 3 Digits Position 1 = 0, 4, 5 (72), (72), (72)

(8) Top 3 Digits Position 2 = 6, 4, 8 (75), (64), (60)

(1) Top 3 Digits Posi... [ More ]

Reply #1

winsumloosesum — Tue, 23 Dec 2014 21:24:23 GMT

Here you go:

https://app.box.com/s/on4qzn08h1oyzg5425df

Instructions:

Excel file contains 4 Tabs at the bottom.

Use the Tabs for CA3D (California Midday Draws), CA3E (California Evening Draws), and CA3C (California Combined Draws)

I'll use the CA3D Tab as the example. Same applies to the other 2 Tabs CA3E and CA3C

Click the Tab labeled CA3D

Notice there are 2 Toolbars in cell Column B1:B13

Toolbar 1 Click To Add New Drawing . Clicking this toolbar will add a new date... [ More ]

Need help with Excel

theo1946 — Tue, 23 Dec 2014 20:04:54 GMT

I am in need of some help my excel data. What I would like to do is find out how many times a specific number is followed by a specific number.

Example would be; how many times was the number 5 followed by number 6.

Thank you all,

Merry Christmas,

Ted