LinkBack URL
About LinkBacks
to detect double and triple strings
last digit
separate the last digits from 0 to 9
* then you will detect double and triple digit
* in each draw line please
https://www.excelforum.com/attachmen...1&d=1560170408
to detect double and triple strings
last digit
separate the last digits from 0 to 9
* then you will detect double and triple digit
* in each draw line please
https://www.excelforum.com/attachmen...1&d=1560170408
You need to spend more time explaining what you are looking for.
Ok DAVE, step 1, you have to separate
the last digits of the draw line
ex = 17 the digit 7 is last digit
Step 2 add the number of digits to form the string, let's assume that after separating the last 15
digit we have the digit 6 repeated twice then it
is 66 another ex = if it has 3 digits 4 then it is in the string
444
ie the macro or formula will add up to the amount of
of digits
In AG6, enter:
Formula:
=IF(SUMPRODUCT((MOD($A5:$O5,10)=MOD(AG$4,10))+0)>=LEN(AG$4),"x",0)
Copy across / down.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
ok OLLY, perfect, conglatutations, thank you!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
,
Bookmarks