+ Reply to Thread
Results 1 to 7 of 7

Identify by position the number of a draw list.

  1. #1
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,761

    Identify by position the number of a draw list.

    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
    Attached Files Attached Files
    Last edited by AliGW; 11-09-2017 at 04:40 AM.

  2. #2
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,761

    Re: Request = identify by position the number of a draw list.

    hello please

  3. #3
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    4,556

    Re: Request = identify by position the number of a draw list.

    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

  4. #4
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,761

    Re: Request = identify by position the number of a draw list.

    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

  5. #5
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,761

    Re: Request = identify by position the number of a draw list.

    hello, please!!!

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    47,610

    Re: Identify by position the number of a draw list.

    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!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  7. #7
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,761

    Re: Identify by position the number of a draw list.

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. request = classify the 5.41 trainings 23 ... 11111 in each draw line
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-28-2017, 12:43 PM
  2. Request = to locate the 5 letters in each line of draw in the 10 positions
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-07-2017, 02:40 PM
  3. Replies: 1
    Last Post: 05-09-2012, 01:30 PM
  4. Replies: 4
    Last Post: 09-12-2011, 12:00 PM
  5. Replies: 6
    Last Post: 05-10-2011, 11:30 AM
  6. Identify Change in Grade or Position - Loop
    By ronanm in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-14-2011, 09:23 AM
  7. Can I identify a number from text in a list?
    By Ron in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-26-2005, 12:20 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1