+ Reply to Thread
Results 1 to 3 of 3

detect the 4 patterns only **

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

    detect the 4 patterns only **

    detect the 4 patterns only
    ** in the last digit
    goal = identify the 4 patterns, low, high, even, od
    https://www.excelforum.com/attachmen...1&d=1567871018
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: detect the 4 patterns only **

    Hi,

    It's not at all clear (at least to me) what it is you're trying to achieve.

    One thing you must keep in mind when you ask a question in a forum... the people you are asking to help you know absolutely nothing about your data. Absolutely nothing about which is data and which is results, absolutely nothing about what you want done with it and absolutely nothing about how whatever it is you want done is to be presented back to you as a result.
    You must be very specific about describing each of these areas in detail referring to specific cells , and you should not assume that we will be able to "figure it out" on our own. Remember, you are asking us for help... so help us to be able to help you by providing the information we need to do so, even if that information seems "obvious" to you (remember, it is only obvious to you because of your familiarity with your data).
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

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

    Re: detect the 4 patterns only **

    ok Richard
    * 1st step, find within 07-19
    the numbers on each draw line
    * 2nd step only last digit, detect the 4 patterns
    * ex = last digit = 17 the digit 7 last digit,
    identify in each of the 4 patterns the last digit

+ 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] separate the 5 triplets and detect the 8 matching odd / even patterns.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-25-2019, 05:27 PM
  2. please, detect in the 100 pairs, the pairs of the 16 patterns,
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-23-2019, 06:07 AM
  3. [SOLVED] detect the 4 patterns * after separating the last digit
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-21-2019, 10:38 AM
  4. detect the 3 patterns, bigger smaller and equal with the colors.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-15-2019, 07:10 PM
  5. Finding patterns
    By GaidenFocus in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-06-2012, 03:59 PM
  6. Converting 2007 VBA color patterns to 2003 color patterns
    By ChemistB in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-13-2011, 12:00 PM
  7. patterns
    By DArinello in forum Excel Formulas & Functions
    Replies: 60
    Last Post: 09-06-2005, 06: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