Formula for Pick 4 and Pick 5 workout.

MrsFrankieH

Active Member
Joined
Mar 25, 2011
Messages
323
Office Version
  1. 365
Platform
  1. Windows
Hello,

I'm using Windows 7 and Excel 2010. Could you please help me (show me how) to write formulas for these workouts? My workout starts a bit further down the page, i hope that's ok.http://





Thank you very very very much! :)

Frankie

P.S.- This is my first "link" post.
 
Hello Buxtongt,

Thank you for the formulas. As soon as i'm back home, i will try the latest formula. I tried to use the formula for 'repeaters' for pick 3. Since i don't understand formulas yet, i couldn't get it to work for pick 3 (three digits). Can you show me a formula for 'repeaters' that works on three digits?

Thank you so much for you help! I'll keep you updated when i'm able to work with this new formula.

Thank you again,

Frankie
 
Upvote 0

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Dear BJungheim,

Thank you for the formulas. I can't wait to get home to try them! When i receive a formula, i work them all. It helps me learn how the formula works. I'm really excited and i can't wait to try out your formulas! I will keep you updated! Thank you. I will try out the 'leap frog' formula first.

I really appreciate your help.

Many Thanks,

Frankie :)
 
Upvote 0
Thank you Buxtongt,

Your formulas worked perfectly!!!! I appreciate your help!! Thank you very very much!! :)
 
Upvote 0
Thank you BJungheim,

I also used your formulas! You really were spot on with the "Leap Frog"! Well done!!
Thank you for your help!


 
Upvote 0

Forum statistics

Threads
1,216,085
Messages
6,128,732
Members
449,465
Latest member
TAKLAM

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top