Welcome Guest
Log In | Register )
You last visited January 22, 2017, 5:12 pm
All times shown are
Eastern Time (GMT-5:00)

search feature

Topic closed. 9 replies. Last post 9 years ago by ducksafloat.

Page 1 of 1
PrintE-mailLink
ducksafloat's avatar - animal duck.jpg
Wentzville, Missouri
United States
Member #2243
September 4, 2003
8519 Posts
Offline
Posted: August 16, 2007, 2:40 pm - IP Logged

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

Rubber DuckMade 2-B Pro$perou$ & Powerful!
Ya' Gotta Love Thi$ Place! wMim

    Todd's avatar - Cylon 2.gif
    Chief Bottle Washer
    New Jersey
    United States
    Member #1
    May 31, 2000
    23351 Posts
    Online
    Posted: August 16, 2007, 7:14 pm - IP Logged

    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.

     

    Check the State Lottery Report Card
    What grade did your lottery earn?

     

    Sign the Petition for True Lottery Drawings
    Help eliminate computerized drawings!

      ducksafloat's avatar - animal duck.jpg
      Wentzville, Missouri
      United States
      Member #2243
      September 4, 2003
      8519 Posts
      Offline
      Posted: August 17, 2007, 1:08 am - IP Logged

      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 that good with excel, i understand if u don't have time to help me.  ;-)

      Rubber DuckMade 2-B Pro$perou$ & Powerful!
      Ya' Gotta Love Thi$ Place! wMim

        Todd's avatar - Cylon 2.gif
        Chief Bottle Washer
        New Jersey
        United States
        Member #1
        May 31, 2000
        23351 Posts
        Online
        Posted: August 17, 2007, 1:17 am - IP Logged

        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.

         

        Check the State Lottery Report Card
        What grade did your lottery earn?

         

        Sign the Petition for True Lottery Drawings
        Help eliminate computerized drawings!

          ducksafloat's avatar - animal duck.jpg
          Wentzville, Missouri
          United States
          Member #2243
          September 4, 2003
          8519 Posts
          Offline
          Posted: August 17, 2007, 1:23 am - IP Logged

          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

          Rubber DuckMade 2-B Pro$perou$ & Powerful!
          Ya' Gotta Love Thi$ Place! wMim

            ducksafloat's avatar - animal duck.jpg
            Wentzville, Missouri
            United States
            Member #2243
            September 4, 2003
            8519 Posts
            Offline
            Posted: August 17, 2007, 1:29 am - IP Logged

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

            Rubber DuckMade 2-B Pro$perou$ & Powerful!
            Ya' Gotta Love Thi$ Place! wMim

              ducksafloat's avatar - animal duck.jpg
              Wentzville, Missouri
              United States
              Member #2243
              September 4, 2003
              8519 Posts
              Offline
              Posted: August 17, 2007, 1:33 am - IP Logged

              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
                Thu, Aug 16, 2007KansasPick 36/1/2009

              Rubber DuckMade 2-B Pro$perou$ & Powerful!
              Ya' Gotta Love Thi$ Place! wMim

                ducksafloat's avatar - animal duck.jpg
                Wentzville, Missouri
                United States
                Member #2243
                September 4, 2003
                8519 Posts
                Offline
                Posted: August 17, 2007, 1:38 am - IP Logged

                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, 2007IllinoisMidday 32-8-8
                  Tue, Jul 31, 2007IllinoisDaily 38-0-5
                  Tue, Jul 31, 2007IllinoisMidday 37-0-6
                  Mon, Jul 30, 2007IllinoisDaily 36-7-0
                  Sun, Jul 29, 2007IllinoisDaily 36-3-0
                  Sat, Jul 28, 2007IllinoisDaily 38-2-9
                  Fri, Jul 27, 2007IllinoisDaily 36-0-6
                  Fri, Jul 27, 2007IllinoisMidday 32-6-5
                  Tue, Jul 24, 2007IllinoisDaily 38-0-0
                  Mon, Jul 23, 2007IllinoisDaily 37-6-7

                this is what happened in excel:

                • Thu, Aug 16, 2007IllinoisDaily 38-0-6
                  Fri, Aug 10, 2007IllinoisMidday 36/3/2000
                  Thu, Aug 9, 2007IllinoisDaily 38/6/2000
                  Tue, Aug 7, 2007IllinoisDaily 38/6/2005
                  Tue, Aug 7, 2007IllinoisMidday 38/5/2007
                  Sat, Aug 4, 2007IllinoisDaily 30-6-2
                  Sat, Aug 4, 2007IllinoisMidday 36/1/2007
                  Fri, Aug 3, 2007IllinoisDaily 36/5/2007
                  Fri, Aug 3, 2007IllinoisMidday 36/8/2001
                  Thu, Aug 2, 2007IllinoisDaily 36/1/2004
                  Wed, Aug 1, 2007IllinoisMidday 32/8/2008
                  Tue, Jul 31, 2007IllinoisDaily 38-0-5
                  Tue, Jul 31, 2007IllinoisMidday 37-0-6
                  Mon, Jul 30, 2007IllinoisDaily 36/7/2000
                  Sun, Jul 29, 2007IllinoisDaily 36/3/2000
                  Sat, Jul 28, 2007IllinoisDaily 38/2/2009
                  Fri, Jul 27, 2007IllinoisDaily 36-0-6
                  Fri, Jul 27, 2007IllinoisMidday 32/6/2005
                  Tue, Jul 24, 2007IllinoisDaily 38-0-0
                  Mon, Jul 23, 2007IllinoisDaily 37/6/2007

                Rubber DuckMade 2-B Pro$perou$ & Powerful!
                Ya' Gotta Love Thi$ Place! wMim

                  Todd's avatar - Cylon 2.gif
                  Chief Bottle Washer
                  New Jersey
                  United States
                  Member #1
                  May 31, 2000
                  23351 Posts
                  Online
                  Posted: August 17, 2007, 7:22 am - IP Logged

                  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.

                   

                  Check the State Lottery Report Card
                  What grade did your lottery earn?

                   

                  Sign the Petition for True Lottery Drawings
                  Help eliminate computerized drawings!

                    ducksafloat's avatar - animal duck.jpg
                    Wentzville, Missouri
                    United States
                    Member #2243
                    September 4, 2003
                    8519 Posts
                    Offline
                    Posted: August 17, 2007, 4:06 pm - IP Logged

                    ok, got it!  thank u!Lovies

                    Rubber DuckMade 2-B Pro$perou$ & Powerful!
                    Ya' Gotta Love Thi$ Place! wMim