separate pairs without repetition of digits, that is 4 distinct digits
ex = 01 40 = not because there is a zero digit repetition
01 49 = yes, because there is no repetition of digits, we have 4 distinct digits
https://www.excelforum.com/attachmen...1&d=1618519707
Column A copied to Column D
Formula in E5 then copied down
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.
ok kvs,ok, but you can't ex = 42, 11 or 28,
we have gigite 1 repeated in the duo can't 11,
objective is to separate in a list the formation of pairs with 4 digits if they are repeated ok
Column C is used as helper column.
In C5 then copied down
For list.Please Login or Register to view this content.
In F5 then copied across to column G
Please Login or Register to view this content.
Stick to helper solution, column C, but a bit shorter:
C5, to mark row#:
=IF(SUMPRODUCT(--ISNUMBER(SEARCH(ROW($1:$10)-1,TEXT(A5,"00")&TEXT(B5,"00"))))=4,ROW(),"")
Drag down
Then in F5:
Copy down and accrossPlease Login or Register to view this content.
Quang PT
helloKVS and BEBO now this is correct, great job, congratulations, the goal is to filter the starting double of my lottery (one of them) corner 80/5 in this pattern.
last draw was = 13,24,30,33,43 = note that 13,24 the double inicailk gave in the pattern of 4 different digits ie filtered in the pattern, this happens in more than 70% of the draws, therefore the filtering by this kind of pattern, thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks