Welcome Guest
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
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.

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

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.

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."

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.

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

 Page 1 of 1