Request = identify by position the number of a draw list
We have a list of draws of the 80-5 (which will be updated every week, so the macro has to do automatic) the macro will identify in the list of suits the presence of the number in a color
* Then the objective is to separate formations from suits that have zero =
* Ex = 0 0 0 separate from a list
https://www.excelforum.com/attachmen...1&d=1510142212
Last edited by AliGW; 11-09-2017 at 04:40 AM.
hello please
Hum ..!
" identify in the list of suits the presence of the number in a color" what do you mean ???
Can you explain with details how you will do manually.
- Battle without fear gives no glory - Just try
Hello, if it is difficult, with color, there is no need of color, can do without color
Objective = is to find formations in zeroed suits, formations that have not yet been drawn with zero values in the 3 positions. do not need color
hello, please!!!
Maybe you need to explain the issue again?
Off topic, but please will you NOT prefix your thread titles with "Request ="? For members using small screens (e.g. tablets, phones, etc.), it means that they can't see the relevant part of the thread title. Thanks.
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.
Okay, ALIGW so here we go, we have a list of sororios of 5 numbers, next to a list of suits, or
* Set of three numbers, macro will identify formations in this list with
* Hit zero
Ex = 12 29 78 = 0 hits
******* 12 36 75 = 1 hit
******** 12 34 68 = 2 hits
But if with 1 and 2 hits is complicated, do only with zero hits
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks