hello, please someone has the 300 formations * in ascending order of 7200 from pick4? *
hello, please only, has the 300 formations
* in ascending order of 7200 from pick4?
* well= 0123 ... 6789
hello, please someone has the 300 formations * in ascending order of 7200 from pick4? *
hello, please only, has the 300 formations
* in ascending order of 7200 from pick4?
* well= 0123 ... 6789
Could you please be a bit more explicit?
ok PEPE on pick 4 we have 7200 singles formations (with single digits without repetition
* example
8516,1658 .... we have 24 possibilities = only need a formation order ascending = 1568
Here's how I did it:
0) I know I have linked this for you before, but I started with my permutation generator spreadsheet here: https://www.excelforum.com/tips-and-...thout-vba.html
1) Deleted the dinosaur columns, because this is not using text.
2) Copied column D into column E so there would be 4 digits.
3) Copied the bottom row down to about row 8000 to generate all permutations between 0000 and 7999.
At this point I have quickly generated all possible permutations. Now I need to go through and reject all those that do not match my desired criteria. I was not sure what your criteria are, but it looks like you are looking for A) 4 digits -> B) All unique -> C) in ascending order. 4 digits is taken care of by having only 4 columns, so I just need to test the other two critieria.
4) To test for all unique, I set up a conditional count to see if any digit occurs more than once.
4a) In G4:P4, I enter the numbers 0 to 9.
4b) In G5, I enter a COUNTIFS() function =COUNTIFS($B5:$E5,G$4) -- note the mix of relative and absolute references. Copy across to P5.
4c) In Q5, I enter =MAX(G5:P5)=1. If all digits are unique, this will return TRUE. If any digit is repeated, this will return FALSE.
5) To test for sort order, I use a simple AND() function. In R5, I enter =AND(B5<C5,C5<D5,D5<E5). This will return TRUE if the digits are in ascending order and FALSE if any digits are out of order.
6) Combine the two tests. In S5 =AND(Q5:P5). This will return TRUE if both tests are TRUE, and FALSE if either test is FALSE.
7) Select G5:S5 and copy/fill down.
Now I know which entries fit my criteria, I would like an easier way to see only the entries that fit, so I set up a filter on the list.
8) Select G5 -> Data -> Filter to set up the Autofilter on this list. Then select the dropdown for column S and deselect the FALSE entries. All entries that do not fit both criteria I have set up are hidden.
That certainly isn't the only way to do this, but it went together pretty quick starting from that sample file I created a while ago.
I won't be in a position to upload a sample file for a day or two. Is there any of those steps that you have trouble implementing on your own?
Originally Posted by shg
hello please i can not, can you by the file to download?
It will be a while (maybe until the weekend) before I can upload a file. If you are willing to wait, I guess that's okay. It seems to me that we could coach you through these steps long before I can get around to uploading a file. I have to think that steps 1 through 3 are pretty straightforward. Which step or which formula are you having trouble with?
Before I go to the trouble of uploading a spreadsheet, did you solve this problem in the other thread? https://www.excelforum.com/excel-pro...-criteria.html
Okay, I got it, great job.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks