LinkBack URL
About LinkBacks
detect each corresponding number
of the draw line
goal = is to locate each number within the group
* 01 to 25 of the yellow band
https://www.excelforum.com/attachmen...1&d=1563900688
detect each corresponding number
of the draw line
goal = is to locate each number within the group
* 01 to 25 of the yellow band
https://www.excelforum.com/attachmen...1&d=1563900688
let me see if i can understand what it is that you want done. looking at this now.
I gave you a formula solution for an almost identical problem quite some time ago. Search your PC for the workbook I provided for you then (it probably has AliGW in its title) and adapt the formula to suit this scenario.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
so question on your workbook. in cell AI5, you have an x, but the data in row 5 does not match that. was this a mistake or intended?
ok sorry DMC it was a mistake
you must delete the markup
* at number 19 because it's not in the draw line,
the yellow line has been placed in the order
* vertical i already have in horizontal order
01 02 03 04 05
* this work is vertically = 01 06 11 16
21
my goal is to cross cracks in the Cartezian
* you have to detect every number
* correspondingly, there was an error at number 19
so i have the code to put the "x" in the correct spot. just need the count at the end and i will post.
Attached is the solution I offered you almost a year ago. See if you can adapt the formula in Q6 to work for the new scenario.
thanks ALI but the macro
* no good, another macro has to be done
In Q5 copied across to AO5 and then down:
=IF(COUNTIF($A5:$O5,Q$4)=1,"x","")
In AP5 copied down:
=COUNTIF(Q5:AO5,"x")
You don't have to have a macro for something simple like this.
I am looking forward to my share of your winnings.
hello,ALI
error=
01 06 11 16 21 02 07 12 17 22 03 08 13 18 23 04 09 14 19 24 05 10 15 20 25 sum
=IF(COUNTIF($A5:$O5,Q$4)=1,"x","") x x x x x x x x x x x x x x 15
=IF(COUNTIF($A5:$O5,Q$4)=1,"x","") x x x x x x x x x x x x x x 16
=IF(COUNTIF($A5:$O5,Q$4)=1,"x","") x x x x x x x x x x x x x x 17
=IF(COUNTIF($A5:$O5,Q$4)=1,"x","") x x x x x x x x x x x x x x 18
=IF(COUNTIF($A5:$O5,Q$4)=1,"x","") x x x x x x x x x x x x x x 19
=IF(COUNTIF($A5:$O5,Q$4)=1,"x","") x x x x x x x x x x x x x x 20
=IF(COUNTIF($A5:$O5,Q$4)=1,"x","") x x x x x x x x x x x x x x 21
=IF(COUNTIF($A5:$O5,Q$4)=1,"x","") x x x x x x x x x x x x x x 22
=IF(COUNTIF($A5:$O5,Q$4)=1,"x","") x x x x x x x x x x x x x x 23
=IF(COUNTIF($A5:$O5,Q$4)=1,"x","") x x x x x x x x x x x x x x 24
=IF(COUNTIF($A5:$O5,Q$4)=1,"x","") x x x x x x x x x x x x x x 25
=IF(COUNTIF($A5:$O5,Q$4)=1,"x","") x x x x x x x x x x x x x x 26
=IF(COUNTIF($A5:$O5,Q$4)=1,"x","") x x x x x x x x x x x x x x 27
=IF(COUNTIF($A5:$O5,Q$4)=1,"x","") x x x x x x x x x x x x x x 28
=IF(COUNTIF($A5:$O5,Q$4)=1,"x","") x x x x x x x x x x x x x x 29
You haven't done it correctly.
Excel 2016 (Windows) 32 bit
sum x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x
Sheet: Planilha1
ok that's ok congratulations my windows is 64 bit my excel 2016
thank you!!! ALIGW, ok
Then update your user profile, please. And mark this thread as solved.
i know this thread is solved, but took awhile to get my solution working. with some help from stackoverflow, this now works. interestingly enough, all the sums are 15.
Please Login or Register to view this content.
hello, DMC, thanks for completing the macro, it's working fine, it's always nice to have two different opinions
of course the sum always has to be 15 because my
* lottery (one of them) is 25/15 ie the draw is 15 numbers, must be 15 markings (x)
* goal = is full and empty crack sequences
* by columns and so you can see patterns,
* When will winning any prize be rewarded? thanks DMC
If it is, it won't be because of any of this stuff you've been getting us to do for you for the past five years - it will be down to luck alone. So, in reality, all of this is a complete waste of everybody's time!* When will winning any prize be rewarded?
great, if you need any more help, let me know.
ALIGW, thank you!! THINK POSITIVE
everything is 80/20.
if you have focus is 80 and not 20
Fact: you have no control over the balls that come out of the machine when the lottery is drawn.
"There is no such thing as luck, the divine Jew, etc. just adequate or inadequate preparation for dealing with a statistical universe."
of course i agree that a starting point is missing
* or base or a reference for not circling, but math can help a little with smaller prizes and the big prize comes from the ride, we haven't learned enough yet
* to go mathematically to some extent, I agree that 100% control will never have, but prizes
* small.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks