- Home
- Premium Memberships
- Lottery Results
- Forums
- Predictions
- Lottery Post Videos
- News
- Search Drawings
- Search Lottery Post
- Lottery Systems
- Lottery Charts
- Lottery Wheels
- Worldwide Jackpots
- Quick Picks
- On This Day in History
- Blogs
- Online Games
- Premium Features
- Contact Us
- Whitelist Lottery Post
- Rules
- Lottery Book Store
- Lottery Post Gift Shop
The time is now 2:09 pm
You last visited
April 24, 2024, 6:51 am
All times shown are
Eastern Time (GMT-5:00)
Pick 4 Permutations In Excel
Published:
Stumbled across a question in the Pick 4 Forum the other day about inputting a 4-digit number in Excel and having the spreadsheet return all possible 24 permutations. I answered it but it was a PITA to formulate and edit my response. I thought about it for a while and came up with an easier way to construct the formulas. The Excel output is still the same no matter whether the formulas in my response in the Pick 4 Forum are used or copied from this entry. Here goes:
=(MID(A1,1,1)*1000)+(MID(A1,2,1)*100)+(MID(A1,3,1)*10)+(MID(A1,4,1)*1)
=(MID(A1,1,1)*1000)+(MID(A1,2,1)*100)+(MID(A1,4,1)*10)+(MID(A1,3,1)*1)
=(MID(A1,1,1)*1000)+(MID(A1,3,1)*100)+(MID(A1,2,1)*10)+(MID(A1,4,1)*1)
=(MID(A1,1,1)*1000)+(MID(A1,3,1)*100)+(MID(A1,4,1)*10)+(MID(A1,2,1)*1)
=(MID(A1,1,1)*1000)+(MID(A1,4,1)*100)+(MID(A1,2,1)*10)+(MID(A1,3,1)*1)
=(MID(A1,1,1)*1000)+(MID(A1,4,1)*100)+(MID(A1,3,1)*10)+(MID(A1,2,1)*1)
=(MID(A1,2,1)*1000)+(MID(A1,1,1)*100)+(MID(A1,3,1)*10)+(MID(A1,4,1)*1)
=(MID(A1,2,1)*1000)+(MID(A1,1,1)*100)+(MID(A1,4,1)*10)+(MID(A1,3,1)*1)
=(MID(A1,2,1)*1000)+(MID(A1,3,1)*100)+(MID(A1,1,1)*10)+(MID(A1,4,1)*1)
=(MID(A1,2,1)*1000)+(MID(A1,3,1)*100)+(MID(A1,4,1)*10)+(MID(A1,1,1)*1)
=(MID(A1,2,1)*1000)+(MID(A1,4,1)*100)+(MID(A1,1,1)*10)+(MID(A1,3,1)*1)
=(MID(A1,2,1)*1000)+(MID(A1,4,1)*100)+(MID(A1,3,1)*10)+(MID(A1,1,1)*1)
=(MID(A1,3,1)*1000)+(MID(A1,1,1)*100)+(MID(A1,2,1)*10)+(MID(A1,4,1)*1)
=(MID(A1,3,1)*1000)+(MID(A1,1,1)*100)+(MID(A1,4,1)*10)+(MID(A1,2,1)*1)
=(MID(A1,3,1)*1000)+(MID(A1,2,1)*100)+(MID(A1,1,1)*10)+(MID(A1,4,1)*1)
=(MID(A1,3,1)*1000)+(MID(A1,2,1)*100)+(MID(A1,4,1)*10)+(MID(A1,1,1)*1)
=(MID(A1,3,1)*1000)+(MID(A1,4,1)*100)+(MID(A1,1,1)*10)+(MID(A1,2,1)*1)
=(MID(A1,3,1)*1000)+(MID(A1,4,1)*100)+(MID(A1,2,1)*10)+(MID(A1,1,1)*1)
=(MID(A1,4,1)*1000)+(MID(A1,1,1)*100)+(MID(A1,2,1)*10)+(MID(A1,3,1)*1)
=(MID(A1,4,1)*1000)+(MID(A1,1,1)*100)+(MID(A1,3,1)*10)+(MID(A1,2,1)*1)
=(MID(A1,4,1)*1000)+(MID(A1,2,1)*100)+(MID(A1,1,1)*10)+(MID(A1,3,1)*1)
=(MID(A1,4,1)*1000)+(MID(A1,2,1)*100)+(MID(A1,3,1)*10)+(MID(A1,1,1)*1)
=(MID(A1,4,1)*1000)+(MID(A1,3,1)*100)+(MID(A1,1,1)*10)+(MID(A1,2,1)*1)
=(MID(A1,4,1)*1000)+(MID(A1,3,1)*100)+(MID(A1,2,1)*10)+(MID(A1,1,1)*1)
Enter each formula into individual spreadsheet cells where you would like to view each permutation.
The response in the Forum took about an hour to edit properly, the above was done in about 10 minutes in a text editor.
The formulas assume your initial 4-digit entry will be in Cell A1; if in any other place, the formula where "A1" appears will need to be edited to your preferred entry location. The results of these formulas will be numeric - if text results are desired one may eliminate the "*1000", "*100", "*10" and "*1" portions of the formulas along with the outermost set of parentheses in each part of the formula - example:
=MID(A1,1,1)+MID(A1,2,1)+MID(A1,3,1)+MID(A1,4,1)
gl
Comments
This Blog entry currently has no comments.
Post a Comment
Please Log In
To use this feature you must be logged into your Lottery Post account.
Not a member yet?
If you don't yet have a Lottery Post account, it's simple and free to create one! Just tap the Register button and after a quick process you'll be part of our lottery community.
Register