Excel help (dates and draws)

Reply #33

alchemist7 — Tue, 27 Nov 2012 16:08:04 GMT

I know its a month later but I finally buckled down and worked on the code and got it to do what I wanted! Thanks to phileight for the starting point and pointers! I will post the code below (its not as neat and organized as the original but it works for me).

Sub dates()

' #'s data starts on line 2 col A-D date is in col F

' comb to look for is in line 1 col J-M this can also be stated as Column 10-13 numbers are usually easier to program

' where is the results goin... [ More ]

Reply #32

phileight — Fri, 02 Nov 2012 09:36:59 GMT

happy to help. I generally look in morn and eve if you get stuck. p8

Reply #31

alchemist7 — Fri, 02 Nov 2012 00:27:03 GMT

Thanks everyone for all of your help! I had some issues and being busy, I didn't have very much time to work on this until tonight!

Phileight, thanks for the macro! It works great! With your comments it will help me tweak it to work on a larger section of lookup numbers. I'm going to work on it some more tonight and this weekend. I will post the finished results and the code for anyone else ( it probably won't be simple as yours, because loops give me alot of trouble).

Again everyone... [ More ]

Reply #30

SergeM — Mon, 29 Oct 2012 10:57:46 GMT

Reply #29

phileight — Mon, 29 Oct 2012 00:03:41 GMT

Sergio I don't play these games. glad you were able to correct my problems. share so we can see the error of my ways.

Reply #28

SergeM — Sun, 28 Oct 2012 22:55:03 GMT

I have no problem with it, I debugged it.

If you are running that code without problems then you are a liar.

Reply #27

phileight — Sun, 28 Oct 2012 22:45:04 GMT

CarliG can you set a file ,same format as alchemist7, see if you find any problem with the code. value to be looked for needs to be in JKLM row 1

thanks

Reply #26

phileight — Sun, 28 Oct 2012 22:26:53 GMT

It works on my computer. what specific problem or problems are you having

Reply #25

SergeM — Sun, 28 Oct 2012 21:43:55 GMT

to phileight:

That code is full of mistakes and won't work.

Reply #24

CarliG — Sun, 28 Oct 2012 19:09:56 GMT

Very Nice Serge

Thank You

Carlig

Reply #23

SergeM — Sun, 28 Oct 2012 17:10:44 GMT

Reply #22

SergeM — Sun, 28 Oct 2012 15:26:08 GMT

Example

Show me all dates with couples of 4's.

Reply #21

SergeM — Sun, 28 Oct 2012 12:49:31 GMT

Date when a number was drawn.

When you mean digit by number

New headers 0 to 9 on the right. Enter function below, if number is in this row, then write the date (6th column here, should be first one)

When you mean number by number

Concatenate and convert to number the 4 digits. New headers: 0 to 9999. Enter function: if number is in this row, then write the date.

Now you have under each number the full list of dates. Adding a new drawing under the list, copy paste function above t... [ More ]

Reply #20

phileight — Sun, 28 Oct 2012 12:31:01 GMT

The bad thing about a macro it is generally writen for a specific purpose and a specific data set. if you can follow the code it can be modified, but you need to understand what the programmer was trying to do. If you understand that you would would probably just write your own.

Alchemist7 if your data is set up like your example, and it probably is not then this macro will look for 4 values you place in row 1 col J-M and show any matches below. I have included many comments to make it easier... [ More ]

Reply #19

CarliG — Sun, 28 Oct 2012 04:31:42 GMT

I can get the formula to work but I cant get the format right for like the date so it will pick it up .

but if I put in something besides date it does give me what I want %^ *(* ^* .. Heck, At least Im trying lol

If I put in red it gives me red, but when I put date , changes it up

xxx xxxxx xxx xxx Lookup

6843 Mid-Day Thursday Red 6843 Thursday Red

1500 Mid-Day Wednesday October 24, 2012 * Monday 41204

4449 Mid-Day Tuesday October 23, 2012 * Friday 39885

CG

Reply #18

four4me — Sun, 28 Oct 2012 04:22:41 GMT

Lottery post has a data base of every states numbers look on the blue menu bar under results.

You may be able to obtain a number history file from your state lottery in excel format also.

Reply #17

Pogo — Sun, 28 Oct 2012 04:13:41 GMT

Excellent Work! Wow, everytime I start touching column or row... It blows up in my face! lol -Pogo

Reply #16

alchemist7 — Sat, 27 Oct 2012 22:39:11 GMT

Thanks CarliG,

I will give it a shot and let you know how it works.

Thanks again

Reply #15

CarliG — Sat, 27 Oct 2012 21:09:40 GMT

If your good at adjusting formulas, I think this will do what you want with no macro

If I get a chance later , I will play with it Its an array formula so need to control/shift/enter

=IF(ROW($A2)-ROW($A$1) COUNTIF($A$3:$A$261,$I$3), ,INDEX($D$1:$D$261,SMALL(IF($A$3:$A$261=$I$3,ROW($D$3:$D$261)),ROW($A2)-ROW($A$1))))

Carlig

Reply #14

alchemist7 — Sat, 27 Oct 2012 04:29:48 GMT

Mzduffle,

Could you tell me how to make a sheet like the one that you have pictured

Reply #13

MzDuffleBaglady — Sat, 27 Oct 2012 04:18:45 GMT

O.K.

I would be playing that number in your state, it's due.

Good Luck.

Reply #12

alchemist7 — Sat, 27 Oct 2012 04:12:14 GMT

Hi Mzdufflebaglady,

This would be great! I think i can tweak to work on a larger scale

Reply #11

MzDuffleBaglady — Sat, 27 Oct 2012 04:09:15 GMT

History of 492 in any order

Number

Draw Date

How many draws ago

Draws between draws

Time between draws

294

Sunday, September 08, 2002(EVE)

6615

185

6m 1d (from start date)

942

Wednesday, September 18, 2002(EVE)

6605

10

10d

492

Thursday, January 02, 2003(EVE)

6499

106

3m 15d

294

Thursday, February 13, 2003(EVE)

6457

42

1m 11d

942

Wednesday, April 16,

Reply #10

alchemist7 — Sat, 27 Oct 2012 04:00:15 GMT

I think the writer of this is turtle047 (not sure of if the name is correct) this is what I'm trying to modify and I know there are much simpler loops than the ones I've written but i just couldn't get it to work! i would be glad for what you can provide!

Sub Macro1()

Ln = 50

Range( A1:u46 ).Select 'selects range of cells

Selection.Interior.ColorIndex = 0 ' removes any color you might have had

c1 = Cells(48, 1)

c2 = Cells(48, 2)

c3 = Cells(48, 3... [ More ]

Reply #9

CarliG — Sat, 27 Oct 2012 03:56:30 GMT

If you know how to modify, Ill be happy to give you what I have

Ill reading excel help forum now lol

CG

Reply #8

alchemist7 — Sat, 27 Oct 2012 03:55:02 GMT

No I don't know more than you. I know when I run certain macros it shows in the window how much of the cpu its using. And the macros i use are just altered ones of somebody elses that i tried to tweak to my purpose (most likely its wrong but it gets the job done).

Thanks for your help anyways

Reply #7

CarliG — Sat, 27 Oct 2012 03:49:39 GMT

Well heck, sounds like you may know more than me ..

Cause I dont know anything about making sure macro doesnt use up percentage of CPU ..

Like I said, sometimes I bite off more than I can chew ..

Ill back off and hope someone else can do it.

Carlig

Reply #6

Pogo — Sat, 27 Oct 2012 03:41:35 GMT

I couldn't think of the words more than you can chew - lol

That sounds great with the macro... I love modifying things.... Well, coming up them from scratch is nice too, but since i haven't done many macros... Yes, modify that thing!

Loving it Staying tuned,

Pogo

Reply #5

alchemist7 — Sat, 27 Oct 2012 03:40:00 GMT

I have a macro that looks up numbers before and after a number on rows and columns.... I was thinking i can changed to do what I want but I don't know how to do it with out using up the percentage of thel cpu, on a big scale.

Reply #4

CarliG — Sat, 27 Oct 2012 03:33:00 GMT

LOL Yeah but sometimes I bite off more than I can chew lol

I have a sheet that looks up draws via macro and gives me what came before and after . I was thinking maybe I could alter it ..

Not sure ..

Carlig

Reply #3

Pogo — Sat, 27 Oct 2012 03:24:04 GMT

CarliG, you are working that excel with gusto. This is a multi-variable sheet that could become an animal fast. You're braver than me... Good Luck let me know, if you want to bounce some ideas around... Pogo Go For It

Reply #2

alchemist7 — Sat, 27 Oct 2012 03:21:25 GMT

Hi CarliG,

Yes you are correct and I have 2010, yes i can run macros and the state is currently SC.

thanks

Reply #1

CarliG — Sat, 27 Oct 2012 01:51:20 GMT

Can you be a little more specific as to what your looking for ?

As I understand you want to enter a draw and have it find all instances boxed and straight and the dates they hit.

Is that correct ??

Do you have excel ? Which version ?

Can you run macros ?

What state are you playing ??

CG

Excel help (dates and draws)

alchemist7 — Sat, 27 Oct 2012 01:42:06 GMT

I wanted to know if anyone in the forum has developed a system that can tell you dates of a combination of the number that was drawn. Below is an example off my state lottery web site for tonights drawn number. If no one has a system, can someone point me in the right direction of getting started? I was trying to have this for a large group of numbers not just one or enter just one at a time.

Thanks for any help!

Digit1 Digit2 Digit3 Digit4 Draw Date

4 4 9 2 Evening 10/26/12