+ Reply to Thread
Results 1 to 9 of 9

detect every pick 3 in your string corresponding.

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

    detect every pick 3 in your string corresponding.

    detect every pick 3 in your string
    corresponding,
    there may be a pick 3 that has more than one string
    the list of the pick3 will be all weekly more draws, macro has to do automatic
    https://www.excelforum.com/attachmen...1&d=1563193054
    Attached Files Attached Files

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: detect every pick 3 in your string corresponding.

    How's your macro knowledge?
    Working on a MAC?
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: detect every pick 3 in your string corresponding.

    hello, KEEb, WINDOWS 7 64 BITS, PLEASE

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: detect every pick 3 in your string corresponding.

    Try this code:

    Please Login or Register  to view this content.

  5. #5
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: detect every pick 3 in your string corresponding.

    Another approach, similar to used in many of my previous answers:

    Please Login or Register  to view this content.
    Have you ever tried to analyze answers you receive?
    I'm almost sure you could adopt one of previous answers to current question.
    Best Regards,

    Kaper

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,830

    Re: detect every pick 3 in your string corresponding.

    Kaper - your final question and comment have been asked and made before. They will be ignored. Jorel has had literally hundreds of questions answered and never once even tried to make any effort to learn from them. He is far too busy, apparently. The longer people keep handing solutions to him on a plate, the longer he'll keep asking for them. This is why some members have, sadly, stopped offering him help.
    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.

  7. #7
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: detect every pick 3 in your string corresponding.

    AliGW: good to know, that's why the thread went unaswered. Clear, thanks

  8. #8
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: detect every pick 3 in your string corresponding.

    ok hello, Keeb,correct, conglatulations, thank you!!

  9. #9
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: detect every pick 3 in your string corresponding.

    ok,KAPER good job, thanks for replying the post, you are other forum members that always help me, when I win a lottery prize will be rewarded ok thanks

+ 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. [SOLVED] Detect vbCrLf in string
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-13-2018, 07:00 AM
  2. [SOLVED] Pick name out of string
    By AnnieS2Elise in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 07-04-2017, 09:28 AM
  3. Pick out text from middle of a string
    By aaron.phelan12345 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-06-2015, 01:00 PM
  4. [SOLVED] How to pick the last whole number in a string
    By pilak in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-29-2013, 01:23 AM
  5. Detect last time a string of text was used
    By BBL in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-29-2012, 05:59 PM
  6. Parse a String and detect ALT-ENTER?
    By KroogerFx in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-31-2009, 04:19 AM
  7. [SOLVED] how to Detect paragraph in cell in string?
    By dm16s in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-22-2005, 05:05 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