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

A little More Excel help

Topic closed. 2 replies. Last post 5 years ago by Sage.

Page 1 of 1
PrintE-mailLink
Sage's avatar - Lottery-035.jpg
Dunwoody Georgia
United States
Member #747
September 29, 2002
659 Posts
Offline
Posted: September 28, 2011, 8:33 am - IP Logged

Question let's say cell C1 you  have 012 and in cell C2 you have 357 and cell C3 you have 067 and in cell C4 you have 061?  How do you go through the columns and pick out the matching pairs and put them in another cell maybe D1 and D2 ect?  As long as the pairs match they can be boxed or straight it doesn't matter?  Also let's say you have 7 pick 4 numbers in different cells. 4456, 7899,1234,5678,7688,4322,1563 how can you search through the cells and only pick the double numbers not the whole pick 4 number so the doubles would be 44,99,88,22?    Thanks for all your help.  Hope your having a wonderful day.   

 Smile

It's Never Too Late To Be The Person You Could Of Been!I Agree!

    Avatar
    FL
    United States
    Member #93841
    July 8, 2010
    576 Posts
    Offline
    Posted: September 28, 2011, 10:23 am - IP Logged

    Question let's say cell C1 you  have 012 and in cell C2 you have 357 and cell C3 you have 067 and in cell C4 you have 061?  How do you go through the columns and pick out the matching pairs and put them in another cell maybe D1 and D2 ect?  As long as the pairs match they can be boxed or straight it doesn't matter?  Also let's say you have 7 pick 4 numbers in different cells. 4456, 7899,1234,5678,7688,4322,1563 how can you search through the cells and only pick the double numbers not the whole pick 4 number so the doubles would be 44,99,88,22?    Thanks for all your help.  Hope your having a wonderful day.   

     Smile

    C1 - 012     D1- =Value(mid(C1,1,2))  E1- =Value(mid(C1,2,2))   F1- =Value(left(C1)&Value(mid(C1,3,1)

    This basically puts the pairs in the order they came out in cells D1, E1, F1

    I'm no expert in excel....maybe somone can tell you different

    For you to find matching pairs it's better to line the numbers up from lowest to highest.  This way the smaller number is on the left and the results will show you the matching pairs.

    I have something for your pick 4 question, but I can't find the formula... If I find it I'll let you know

    "It's evolve or die, really, you have to evolve, you have to move on otherwise it just becomes stagnant."

      Sage's avatar - Lottery-035.jpg
      Dunwoody Georgia
      United States
      Member #747
      September 29, 2002
      659 Posts
      Offline
      Posted: September 28, 2011, 10:40 am - IP Logged

      C1 - 012     D1- =Value(mid(C1,1,2))  E1- =Value(mid(C1,2,2))   F1- =Value(left(C1)&Value(mid(C1,3,1)

      This basically puts the pairs in the order they came out in cells D1, E1, F1

      I'm no expert in excel....maybe somone can tell you different

      For you to find matching pairs it's better to line the numbers up from lowest to highest.  This way the smaller number is on the left and the results will show you the matching pairs.

      I have something for your pick 4 question, but I can't find the formula... If I find it I'll let you know

      Thank you so much!  I will try this and see what happens1  Thanks for such a prompt response.  Have a wonderful day.   SmileThumbs Up

      It's Never Too Late To Be The Person You Could Of Been!I Agree!