search feature

Reply #9

ducksafloat — Fri, 17 Aug 2007 20:06:18 GMT

ok, got it! thank u

Reply #8

Todd — Fri, 17 Aug 2007 11:22:16 GMT

When you see the dates materialize on the right, instead of showing pick 3 or pick 4 numbers, that means Excel thinks the data in those cells is a date, so it formats the cell as a date. The cell still conatins the exact info you pasted, by it is being formatted to look like a date. Just highlight all the cells in the right-most column, right-click them and select Format Cells . Then change the format to General or something that preserves the original look of the numbers.

Reply #7

ducksafloat — Fri, 17 Aug 2007 05:38:56 GMT

i searched IL only, but when i paste this in excel, it gives below this section:

Thu, Aug 16, 2007IllinoisDaily 38-0-6

Fri, Aug 10, 2007IllinoisMidday 36-3-0

Thu, Aug 9, 2007IllinoisDaily 38-6-0

Tue, Aug 7, 2007IllinoisDaily 38-6-5

Tue, Aug 7, 2007IllinoisMidday 38-5-7

Sat, Aug 4, 2007IllinoisDaily 30-6-2

Sat, Aug 4, 2007IllinoisMidday 36-1-7

Fri, Aug 3, 2007IllinoisDaily 36-5-7

Fri, Aug 3, 2007IllinoisMidday 36-8-1

Thu, Aug 2, 2007IllinoisDaily 36-1-4

Wed, Aug 1... [ More ]

Reply #6

ducksafloat — Fri, 17 Aug 2007 05:33:58 GMT

ok Todd,

this time i went into the search results page and it still leaves me with the same question, some of the sets show up fine and some of them show up in a date format, c what i mean, how do i get the date out to show the actual set, don't know why that is happening, i have excel 2000

Thu, Aug 16, 2007ConnecticutPlay 38/6/2008

Thu, Aug 16, 2007DelawarePlay 38-0-7

Thu, Aug 16, 2007IllinoisDaily 38-0-6

Thu, Aug 16, 2007IndianaMidday 30-8-8

Thu, Aug 16, 2007IowaPick 38-0-6... [ More ]

Reply #5

ducksafloat — Fri, 17 Aug 2007 05:29:00 GMT

gotta laugh at myself! duh* i c what ur saying, now. i ain't the sharpest skirt in the sto' thank u Todd

Reply #4

ducksafloat — Fri, 17 Aug 2007 05:23:44 GMT

yep, that's what um talking about, i copied and pasted the result page. i clicked on the results for IL in the daily. is that what u meant? or the searching in past results? and then i got the whole first page for IL and copied and pasted.

Thu, Aug 16, 20072-1-58-0-60-4-1-50-7-7-0

Wed, Aug 15, 20075-3-77-3-32-7-4-64-8-1-3

Tue, Aug 14, 20070-5-30-9-25-6-5-16-6-6-1

Mon, Aug 13, 20071-3-10-0-75-2-7-17-8-7-9

Sun, Aug 12, 20072-3-1

Reply #3

Todd — Fri, 17 Aug 2007 05:17:21 GMT

I don't think you're doing the same thing I was mentioning. I'm not saying to do much in Excel, other than pasting the search results. Do al your searching in LP, the copy and paste into Excel, so you can see on the states on one page.

If that's what you're talking about too, then you have my apologies for the mistake.

Reply #2

ducksafloat — Fri, 17 Aug 2007 05:08:36 GMT

Todd,

ok, um trying it now, can u help me? i know how to format the cells for the 4 digits, but i can't do it for the 3 digits, this is what i get, and the state is IL as the example:

Thu, Aug 16, 20072/1/20058-0-60-4-1-50-7-7-0

Wed, Aug 15, 20075/3/2007378052-7-4-64-8-1-3

i clicked on format cell and went to custom and then clicked on the 0 and entered a total of 3 zeros, did the same thing for the pick 4 and the numbers fell into place for the p4 but not the p3, um not th... [ More ]

Reply #1

Todd — Thu, 16 Aug 2007 23:14:33 GMT

You would need to search each separately, and then assemble the results yourself. Excel is very good for compiling results from multiple places, since it is very good a moving and combining numbers, and is generally very flexible.

search feature

ducksafloat — Thu, 16 Aug 2007 18:40:14 GMT

hi Todd,

when running a search, i would like to search the CDT only, without having to view one or all states? is this possible? thanks.

CDTIL, LA, MN, MO, NE, OK, TN, TX, WI