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

Excel help needed...

Topic closed. 4 replies. Last post 8 years ago by Rakster.

Page 1 of 1
PrintE-mailLink
Rakster's avatar - praying hands.jpg
Saskatchewan
Canada
Member #19992
August 9, 2005
2867 Posts
Offline
Posted: October 26, 2008, 12:36 pm - IP Logged

Can anyone tell me if its possible to formulate a cell where I have a pair of numbers.. say 51 and I want to add a digit from the previous days draw to it...

Example... I have pair 51... last nights draw 280

I want to formulate it so I get 512, 518 and 510

I also want to get it so it would give me 251, 815, 015 and 521, 581 and 501

So what I am asking is if its possible to formualte a set number "280" where each of its digits can go independantly into the pair where ever I would like it placed.

I play straights and use about 30 pairs so this is the reason for asking for a formula.

Any help wpuld be greatly appreciated.

Thanks

We are all Lucky... just some of us don't realize it!

    time*treat's avatar - radar

    United States
    Member #13130
    March 30, 2005
    2171 Posts
    Offline
    Posted: October 26, 2008, 10:40 pm - IP Logged

    In A1 format:

     

    formulas
    ABCDE
    1pairdraw1st2nd3rd
    251280=A2&MID(B2,1,1)=A2&MID(B2,2,1)=A2&MID(B2,3,1)
    345951=A3&MID(B3,1,1)=A3&MID(B3,2,1)=A3&MID(B3,3,1)

     

    yields:

     

    results
    ABCDE
    1pairdraw1st2nd3rd
    251280512518510
    345951459455451

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

      Rakster's avatar - praying hands.jpg
      Saskatchewan
      Canada
      Member #19992
      August 9, 2005
      2867 Posts
      Offline
      Posted: October 27, 2008, 8:55 am - IP Logged

      In A1 format:

       

      formulas
      ABCDE
      1pairdraw1st2nd3rd
      251280=A2&MID(B2,1,1)=A2&MID(B2,2,1)=A2&MID(B2,3,1)
      345951=A3&MID(B3,1,1)=A3&MID(B3,2,1)=A3&MID(B3,3,1)

       

      yields:

       

      results
      ABCDE
      1pairdraw1st2nd3rd
      251280512518510
      345951459455451

      Thanks!!

      We are all Lucky... just some of us don't realize it!

        time*treat's avatar - radar

        United States
        Member #13130
        March 30, 2005
        2171 Posts
        Offline
        Posted: October 27, 2008, 7:41 pm - IP Logged

        A1 format ...


        ABCDEF
        1typepairdraw1st2nd3rd
        251X51280=B2&MID(C2,1,1)=B2&MID(C2,2,1)=B2&MID(C2,3,1)
        35X151280=MID(B3,1,1)&MID(C3,1,1)&MID(B3,2,1)=MID(B3,1,1)&MID(C3,2,1)&MID(B3,2,1)=MID(B3,1,1)&MID(C3,3,1)&MID(B3,2,1)
        4X5151280=MID(C4,1,1)&B4=MID(C4,2,1)&B4=MID(C4,3,1)&B4

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

          Rakster's avatar - praying hands.jpg
          Saskatchewan
          Canada
          Member #19992
          August 9, 2005
          2867 Posts
          Offline
          Posted: October 27, 2008, 10:20 pm - IP Logged

          A1 format ...


          ABCDEF
          1typepairdraw1st2nd3rd
          251X51280=B2&MID(C2,1,1)=B2&MID(C2,2,1)=B2&MID(C2,3,1)
          35X151280=MID(B3,1,1)&MID(C3,1,1)&MID(B3,2,1)=MID(B3,1,1)&MID(C3,2,1)&MID(B3,2,1)=MID(B3,1,1)&MID(C3,3,1)&MID(B3,2,1)
          4X5151280=MID(C4,1,1)&B4=MID(C4,2,1)&B4=MID(C4,3,1)&B4

          This is so cool!

          Thank you for everything!

          Wow!!

          We are all Lucky... just some of us don't realize it!