Welcome Guest
Log In | Register )
You last visited December 4, 2016, 1:02 am
All times shown are
Eastern Time (GMT-5:00)

Need some excel lookup and data sort help

Topic closed. 7 replies. Last post 3 years ago by SergeM.

Page 1 of 1
PrintE-mailLink
Avatar
Krypton
United States
Member #140102
March 11, 2013
891 Posts
Offline
Posted: August 12, 2013, 8:51 pm - IP Logged

is it possible to do a data search to look up say the number 33 within an excel spreadsheet?  I want to be able to see how many times and which day ( date ) a specific number is played. 

 

Also, how can I do a sort to put the draw numbers n numerical order rather than draw order?  I have excel 2010 and can only sort 1 string (draw) at a time. I want to be able to do multiples or is there a web site to download them in numerical order. 

 

Thanks y'all !


    United States
    Member #124493
    March 14, 2012
    7023 Posts
    Offline
    Posted: August 13, 2013, 12:20 am - IP Logged

    is it possible to do a data search to look up say the number 33 within an excel spreadsheet?  I want to be able to see how many times and which day ( date ) a specific number is played. 

     

    Also, how can I do a sort to put the draw numbers n numerical order rather than draw order?  I have excel 2010 and can only sort 1 string (draw) at a time. I want to be able to do multiples or is there a web site to download them in numerical order. 

     

    Thanks y'all !

    Sounds kind of like an advanced proposition.

    If you do a search on youtube, Mr Excel has some pretty good videos. 

    I learned how to use VLookup by watching his excercises.  Dont know if any apply to this problem but give a try if you dont get any satisfactory replies.

    good luck.

      SergeM's avatar - slow icon.png
      Economy class
      Belgium
      Member #123700
      February 27, 2012
      4035 Posts
      Offline
      Posted: August 13, 2013, 5:42 am - IP Logged

      Push F1-key in Excel.

        Avatar
        Iron Station, NC
        United States
        Member #74828
        May 21, 2009
        69 Posts
        Offline
        Posted: August 13, 2013, 8:59 am - IP Logged
         ABCDEFGHIJKLM 
        1Date1#2#3#4#5#PBDate1#2#3#4#5#PB
        28/13/20131255113559$A2Small($B2:$F2,1)Small($B2:$F2,2)Small($B2:$F2,3)Small($B2:$F2,4)Small($B2:$F2,5)$G2
        3              
        4              
        5              

         small($B2;$F2,1) for the first small number then copy it across and just change the 1 to 2 then 3 for all five numbers

        use the $ sign to keep the row numberthe same, when it works then copy it down all rows you want changed.

        Use $plus column number and row number to copy just that information  Date and PB

          SergeM's avatar - slow icon.png
          Economy class
          Belgium
          Member #123700
          February 27, 2012
          4035 Posts
          Offline
          Posted: August 13, 2013, 10:23 am - IP Logged
            ABCDEFGHIJKLM 
          1Date12345PB12#3#4#5#PB
          28/13/20131255113559=Small($B2:$F2,H$1)Small($B2:$F2,2)Small($B2:$F2,3)Small($B2:$F2,4)Small($B2:$F2,5)$G2
          3              
          4              
          5

            Avatar
            Krypton
            United States
            Member #140102
            March 11, 2013
            891 Posts
            Offline
            Posted: August 19, 2013, 7:30 am - IP Logged
              ABCDEFGHIJKLM 
            1Date12345PB12#3#4#5#PB
            28/13/20131255113559=Small($B2:$F2,H$1)Small($B2:$F2,2)Small($B2:$F2,3)Small($B2:$F2,4)Small($B2:$F2,5)$G2
            3              
            4              
            5

            Sorry y'all, been busy with life and all but will try this evening. I appreciate your help

              Avatar
              Pennsylvania
              United States
              Member #109275
              April 9, 2011
              1495 Posts
              Offline
              Posted: August 19, 2013, 8:18 pm - IP Logged

              Also in Excel 2007/2010, When you do the sort, click Add Level. This will allow you to sort more options.

                SergeM's avatar - slow icon.png
                Economy class
                Belgium
                Member #123700
                February 27, 2012
                4035 Posts
                Offline
                Posted: August 20, 2013, 10:23 am - IP Logged

                Download the sorted drawings and you don't have to sort.