Kindly help me to get an easy way to find all 24 different combinations of a given 4 digit number
example: given a 4 digit number of 1234
1234, 1342, 1324, 1423, 1432, 2134, 2143, 2314, 2341, 2413, 2431, 3124, 3142, 3214, 3241, 3412, 3421, 4123, 4132, 4213, 4231, 4312, 4321
i need to find a way to find similar numbers if i get any 4 digit number
here is one way without code ps its permutations not combinations
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
How do I, or what is a formula to, get Excel to identify all the same numbers that have the same four-digit numbers in a sequence in a worksheet. e.g. 1234, 4321, 2143 ?
There are one hundred numbers but if 1234 appear together in any order on the worksheet, I want it highlighted or such.
Deleted by JT
Re: 24 combinations for any 4 digit number
Below is what I'm looking for, pls refer to attachment.
1) Enter a 4 digit number then search from the data in the worksheet.
2) After searching, then hi lighted all the combination
rgds
Please create a new thread!
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I am looking for a formula / way to find the 4 digit combination from a work sheet data.
1) Enter a 4 digit number then search and hi lighted all the combination from the data in the worksheet.
Pls refer attachment for more details
CY LO, perhaps you missed my post RIGHT ABOVE yours??
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
thanks - very helpful.
In the example given it is not combinations it is Permutation of 4 digits.
Here is the code for 4 digits Permu
Please Login or Register to view this content.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks