Excel Formula

Reply #8

scott_one — Tue, 17 Jan 2006 03:38:17 GMT

These are just numbers for an example.These are actual numbers from the Michigan midday and evening for the last 2 weeks.01/16/0697401/16/0648201/15/0642101/15/0695501/14/0600301/14/0641701/13/0613301/13/0636001/12/0621801/12/0661801/11/0698801/11/0647401/10/0608901/10/0628201/09/0633901/09/0654701/08/0659501/08/0632201/07/0617301/07/0650301/06/0656801/06/0657001/05/0604401/05/0663201/04/0667401/04/0698001/03/0658101/03/06318

Reply #7

zanbab — Tue, 17 Jan 2006 03:03:52 GMT

it does not work

Reply #6

scott_one — Tue, 17 Jan 2006 02:45:47 GMT

winsumloosesum,Thanks that would be great. scott_one@yahoo.com

Reply #5

winsumloosesum — Mon, 16 Jan 2006 15:29:43 GMT

Scott,I have an Excel Pivot Program that might help.All you do is use the drop down menu to pick the 3 digit number and the corresponding dates will appear next to it.I can send you the file for California Pick 3 if you like.All you would need to do is copy and paste your states drawings in the Drawings Tab.

Reply #4

lottaloot — Mon, 16 Jan 2006 03:12:27 GMT

Well, when you guys get this one, I will be all over it.I thought it would have to be in VBA code. Guess I was wrong.

Reply #3

Amazing Grace — Mon, 16 Jan 2006 02:40:53 GMT

If these are actual numbers entered here as drawn, they look like they follow my Predicatable Sequential Trending method

Reply #2

scott_one — Mon, 16 Jan 2006 01:36:07 GMT

The left 2 columns are the draw history and date of draw. 002 is listed 3 times and I want to know the dates of each draw. Date Last Drawn is what I want to find.NUM DATE NUM DATE LAST DRAWN 002 01/08/06 002 01/08/06 01/03/06 12/27/05 322 01/07/06 003 01/06/06 12/30/05 003 01/06/06 503 01/05/06 568 01/04/06

Reply #1

hypersoniq — Mon, 16 Jan 2006 00:08:48 GMT

you want to see the number drawn before and also the number after?I often wondered how to do that... I came up with a simplisticyet effective solution...1. create a column for the number drawn before (for example E12 has a draw, to capture it on the same line, make F12=E11), do the same for the next draw (G12=E13)...now, use autofilter (select the columns first by highlighting)if you search the main draw for 002, it will pull up not only the date, but the number before and after also.

Excel Formula

scott_one — Sun, 15 Jan 2006 21:36:42 GMT

Hello excel pros, I am trying to list the dates that a certain number has been drawn. I can get the last time a number has been drawn by using this formula:=VLOOKUP(J3,$E:$F,2,FALSE)J3 is the number i'm looking for - ex. 002E is the column with drawn numbers and F is the column with the date.002 has been drawn 9 times and I want a list of all the dates it was drawn.My problem is looking past the last time it was drawn to the time before that that it was drawn and so on.I'm hoping that this makes... [ More ]