For Excel Wizards Only!

Reply #17

BevsPicks2 — Wed, 22 Aug 2007 20:01:51 GMT

Thanks a bunch time*treat. I'm going to try this this weekend. I'll keep you posted

Reply #16

time*treat — Wed, 22 Aug 2007 19:33:58 GMT

VBA = Visual Basic for Applications. It is VB macro language inside excel and other M$ Office apps.

I also want to add that sometimes the code indentations show up right in the preview, but don't post correctly. I hope you can follow what I intended.

Reply #15

BevsPicks2 — Wed, 22 Aug 2007 19:17:17 GMT

time*treat, Thanks a bunch! That is awesome! What language did you say that was

Reply #14

time*treat — Wed, 22 Aug 2007 17:39:03 GMT

@BP3

I had some old TX3 laying around so you will need to make a change or 3

I am guessing that column 8 is where the action is my sample data with layout headersyour columns 1-7 are just copied over, don't worry about mine being different.You want to change texaspick3 and output to whatever you called your sheets

1 2 3 4 5 6 7 8 9 10

1 1st2nd 3rd orderbefore after

2 p3 10 25 93 3 2 9 329

3 p3 10 26 93 8 4 1 841

4 p3 10 27 93 9 6 2 962

some of these... [ More ]

Reply #13

tben — Wed, 22 Aug 2007 16:34:56 GMT

Hi BevsPicks,

I've investigated VLookup a little further. I'm pretty sure it will work for you. You can find it in the Insert pull-down menu under function. Then key in the word VLookup as the function you want, click on it and click OK. You then have to provide parameters. The first is the value you are looking for. If you click on the little box to the right where it asks for this parameter you can then click on a cell you will use to type in the value you are looking for. For exam... [ More ]

Reply #12

BevsPicks2 — Wed, 22 Aug 2007 13:49:57 GMT

Thank you time*treat. Here is a snapshot of the spreadsheet.

datedrawdaymonth1st2nd3rdorderBA

August 21, 2007MiddayTuesdayAug3373372580

August 21, 2007EveningTuesdayAug825258579337

August 20, 2007MiddayMondayAug579579112258

August 20, 2007EveningMondayAug211112136579

August 19, 2007EveningSundayAug316136000112

B and A represent the before and after snapshot as you can see. This list is sorted by date.

The following list is sorted by Number with the B a... [ More ]

Reply #11

Raven62 — Wed, 22 Aug 2007 13:47:12 GMT

The layout sounds similar to the layout of the Lottery Bible (which shows lead and follower combinations).

Reply #10

time*treat — Wed, 22 Aug 2007 13:40:24 GMT

The trick is to write the question in such a way as you could understand the answer.

The code for the input and outputs are column specific.

If you make a little chart (column labels, row and column headers, first few rows of data), your response rate may improve.

Also, the amount of output will vary because some numbers repeat more than others, so you have to specify how you would want to handle that. It can be done in Excel but Access may be better suited for this task.

Reply #9

BevsPicks2 — Wed, 22 Aug 2007 12:40:40 GMT

LOL Hypersoniq...the funny thing is this:

Yesterday morning I did exactly that! Then I had to copy the values of the cells into another column so that when I sort the numbers in ascending order I can see a clear before and after picture. I am going to research the VLookup function today. Maybe that function will allow me to elminate the copying of values. Because you know that once you sort the column the above and below value changes.

Reply #8

BevsPicks2 — Wed, 22 Aug 2007 12:37:28 GMT

Thanks Terry that was very valuable information. I will research that and let you know what happens.

Reply #7

hypersoniq — Wed, 22 Aug 2007 09:51:24 GMT

I have a simple solution

put the previous draw and the next draw on the same row.

for example (if you were using a single combo column)

column 3= the combo, column 4= the previous combo, column 5= the next combo

the combo, if in C3 is in column 3, D3=C2, E3=C4

this way when you filter 1 combo, the previous and next draw also appear in the filtered result...

maybe this could be modified to do what you want

Reply #6

tben — Wed, 22 Aug 2007 09:31:21 GMT

Hi BevsPicks,

Sorry you haven't gotten much response. I think your application might be more a database application and you could try Access. However, in Excel, although I haven't used either function, I think you may be able to do what you want using VLookup and Offsett. You'll have to research those two functions. As I understand it VLookup stands for vertical and would apply to a column of numbers. I believe you lookup some value and based on that access a cell in another column. It... [ More ]

Reply #5

BevsPicks2 — Tue, 21 Aug 2007 13:18:35 GMT

Thanks Carbob

Reply #4

CARBOB — Tue, 21 Aug 2007 13:03:51 GMT

Bev,

Go to WWW.Mrexcel.com they have helped me out many times.

Reply #3

BevsPicks2 — Tue, 21 Aug 2007 12:43:22 GMT

You got that right Raven62...Been working on this one for a while.

Reply #2

Raven62 — Tue, 21 Aug 2007 11:45:23 GMT

Lets just say: It might be easier said than done.

Reply #1

BevsPicks2 — Mon, 20 Aug 2007 18:32:11 GMT

Wow! This is the first time I've ever made a post and had absolutely no replies! This must be a tuffie

For Excel Wizards Only!

BevsPicks2 — Sun, 19 Aug 2007 14:09:07 GMT

Hello Smart Folks!

I need a solution. Here's the scenario.

I have been collecting Pick 3 data for a state.

My basic columns are:

1. Date the number fell

2. Day the number fell

3. Each number in it's own column in the order in which it fell

4. The number in ascending order (ie, 321 fell. The order column lists it as 123.)

5. Draw time (day/evening)

Now what I would like to do is produce a query that give a before and after picture of the previous and subsequ... [ More ]