Help with excel code

Reply #9

winsumloosesum — Sat, 31 Jul 2010 14:02:22 GMT

JM,

Not sure if this is what you wanted.

I created an Excel file foe New York Pick 3 game. There are tabs for Midday, Evening, and Combined draws. You can add new drawings by clicking the Toolbars in each of the Tabs.

I did not include the entire history for the New York Pick 4 game. If you want to provide it to me I will update the Midday, Evening, and Combined draws.

Here is the download link to the Excel file

http://www.box.net/shared/n1y1qv2qup

In addition to the Midday, Ev... [ More ]

Reply #8

Pogo — Fri, 30 Jul 2010 01:50:51 GMT

Both Pick3 Pick4 Followers Systems are available @: http://lottostop.tripod.com/

Both systems also include the ability to store follow on the last 1000 draws.

Enjoy, Pogo

Reply #7

Pogo — Thu, 29 Jul 2010 21:05:18 GMT

Pick3 one is done here: http://lottostop.tripod.com/

Enjoy, Pogo

BTW, Pick4 one - I'm going to try get this one up tonight. Also, I'm going to try update both to hold approximately 1000 past drawings - Stay Tuned

Reply #6

ACPutz — Mon, 26 Jul 2010 17:27:42 GMT

I would write and if statement in the cell next to the three digits - using your example:

cell a1 B1 C1

a2 704 =trunc(a2/100)

a3 175 =trunc(a3/100) =if(b2=1,1,if(b3=1,1,0))

a4 138 =trunc(a4/100) =if(b3=1,1,if(b4=1,1,0))

a5 049 =trunc(a5/100) =if(b4=1,1,if(b5=1,1,0))

Okay - so b2 cell takes 704 and divides by 100 and chops off anything after the decimal - answer 7

b3 - answer 1

b4 answer 1

b5 answer 0

Then the c column looks to see if either that row or the row... [ More ]

Reply #5

Raven62 — Mon, 26 Jul 2010 13:36:43 GMT

What order is your file in? (newest to oldest/oldest to newest)

In your example 704 would follow 175 and 138 would precede 175.

Cell E1=175

Cell E3 =IF($C3=$E$1,$C2, ) copy paste to the rest of the column

Reply #4

phileight — Mon, 26 Jul 2010 10:26:13 GMT

This would be fairly easy with VBA. if interested tell me where your input info will be located and where you want the output to go. do you only want the # following the target # or do you want the date? you said your #'s are in col S, but what row? where is the date? a guess would be col R but do not like to make assumptions.

are you familiar with VBA

Reply #3

jm6256 — Sun, 25 Jul 2010 20:02:48 GMT

I have a spreadsheet with all the past numbers of pick3. What I'm trying to do is this.

for example last night 175 came out. I want to be able to be prompted to enter the previous drawing number then search column S for that number and copy and paste in a different section of the sheet the row containing the searched number and the following row. I want to pick all the rows that usually follows 175.

MON 19-Jul-10 7 0 4 704

SUN 18-Jul-10 9 0 5 175

SUN 18-Jul-10 1 3 8 138

SAT 1... [ More ]

Reply #2

Raven62 — Sun, 25 Jul 2010 19:40:15 GMT

It would be very helpful if you could provide an example of what you are trying to do.

Reply #1

Pogo — Sun, 25 Jul 2010 19:34:08 GMT

Have you already started an excel sheet yet? If you have... PM me and send it - but before you do go to the cells you need help with and enter notes like search this number, in these rows/columns, place results here, etc. I'll help you as much as I can - Pogo

Help with excel code

jm6256 — Sun, 25 Jul 2010 18:48:03 GMT

I want to be able to search my spreadsheet for a number entered in an input box and copy all the results (data from column E through L ) of that row and the row immediately following it, into a different section or sheet. Can anyone help me with the code for this.

thanks