Welcome Guest
Log In | Register )
You last visited December 2, 2016, 2:44 pm
All times shown are
Eastern Time (GMT-5:00)

Simple Combination in Excel

Topic closed. 8 replies. Last post 5 years ago by Raven62.

Page 1 of 1
PrintE-mailLink

United States
Member #67042
November 14, 2008
72 Posts
Offline
Posted: June 13, 2011, 5:53 pm - IP Logged

Hi Everyone,

I'm looking for a simple excel formula  in excel to make combinations from different columns.  I've used the search tool (combination, combinations VBA, column combinations, etc..).  Its probably one out there thats exactly what I want but I can't find the correct wording to pull it up.  I tried adapting some of the ones I did find but failed.  So here is what I'm looking for

 

example

Column A has 3 digits, Column B has 2 digits and Column C has 4 digits.

                                                                     Combinations

A1     B1     C1                                              A1  B1  C1        A1  B1  C2      A1  B1  C3      A1  B1  C4

A2     B2     C2                                              A1  B2  C1        A1  B2  C2      A1  B2  C3      A1  B2  C4

A3              C3                                              A2  B1  C1      ETC................

                  C4

 

Any help is greatly appreciated!

Seachelle

    grwurston's avatar - Cute animals_Spider.jpg
    Winning makes me smile.
    bel air maryland
    United States
    Member #90251
    April 24, 2010
    4849 Posts
    Offline
    Posted: June 13, 2011, 6:23 pm - IP Logged

     Hi Seachelle,

        There's no need to go to excel, just do an LP search for paurths hot cold counter. You can enter your drawn #s, check off whatever #'s you want in each column and it will give you all the possible combinations, for singles, doubles, triples.

         I use it all the time, I even have it in my task bar. LOL.   Good Luck!!

    "You can observe a lot just by watching." Yogi Berra, Hall of Fame baseball player.

    The numbers will tell you what numbers to play. Pay attention to the numbers.

    Don't just think outside the box, crush it.


      United States
      Member #67042
      November 14, 2008
      72 Posts
      Offline
      Posted: June 13, 2011, 6:44 pm - IP Logged

      Thanks Grwurston

       

      I'll give it a try!

        time*treat's avatar - radar

        United States
        Member #13130
        March 30, 2005
        2171 Posts
        Offline
        Posted: June 14, 2011, 3:51 am - IP Logged

        One way to do this is the CONCATENATE function. Here's an example.

        http://www.lotterypost.com/thread/159272

        In neo-conned Amerika, bank robs you.
        Alcohol, Tobacco, and Firearms should be the name of a convenience store, not a govnoment agency.

          Raven62's avatar - binary
          New Jersey
          United States
          Member #17843
          June 28, 2005
          49610 Posts
          Offline
          Posted: June 14, 2011, 4:38 pm - IP Logged

          Hi Everyone,

          I'm looking for a simple excel formula  in excel to make combinations from different columns.  I've used the search tool (combination, combinations VBA, column combinations, etc..).  Its probably one out there thats exactly what I want but I can't find the correct wording to pull it up.  I tried adapting some of the ones I did find but failed.  So here is what I'm looking for

           

          example

          Column A has 3 digits, Column B has 2 digits and Column C has 4 digits.

                                                                               Combinations

          A1     B1     C1                                              A1  B1  C1        A1  B1  C2      A1  B1  C3      A1  B1  C4

          A2     B2     C2                                              A1  B2  C1        A1  B2  C2      A1  B2  C3      A1  B2  C4

          A3              C3                                              A2  B1  C1      ETC................

                            C4

           

          Any help is greatly appreciated!

          Seachelle

          =A1*100+B1*10+C1*1

          The term is: Positional Wheel!

          An alternative to using Excel is Paurth's Pick 3 Wheel Engine:

          https://members.lotterypost.com/paurths

          A mind once stretched by a new idea never returns to its original dimensions!

            SteveC's avatar - istockphoto 1955988-lottery-ball.jpg
            Cincinnati
            United States
            Member #105168
            January 26, 2011
            600 Posts
            Offline
            Posted: June 15, 2011, 7:51 am - IP Logged

            =A1*100+B1*10+C1*1

            The term is: Positional Wheel!

            An alternative to using Excel is Paurth's Pick 3 Wheel Engine:

            https://members.lotterypost.com/paurths

            Thanks Raven.

            I was hoping to find some way to take three digits and break them down into three sets of two.

            Anyone have any ideas on that?

              paradisenow's avatar - 6769831
              nassau
              Bahamas
              Member #103452
              January 2, 2011
              4343 Posts
              Online
              Posted: June 15, 2011, 8:14 am - IP Logged

              thanks for posting


                United States
                Member #67042
                November 14, 2008
                72 Posts
                Offline
                Posted: June 16, 2011, 2:00 pm - IP Logged

                Thanks Everyone for the Help!

                  Raven62's avatar - binary
                  New Jersey
                  United States
                  Member #17843
                  June 28, 2005
                  49610 Posts
                  Offline
                  Posted: June 18, 2011, 4:14 pm - IP Logged

                  Thanks Raven.

                  I was hoping to find some way to take three digits and break them down into three sets of two.

                  Anyone have any ideas on that?

                  Excel formulas for converting Pick 3 to Pairs

                  Assuming Cell B2 is where you enter the 3 digit combo:

                  Cell D: =QUOTIENT(B2/10)

                  Cell E: =QUOTIENT(B2,100)*10+MOD(B2,10)

                  Cell F: =MOD(B2,100)

                  (I have draw date and draw number in columns A and B)

                  A mind once stretched by a new idea never returns to its original dimensions!