+ Reply to Thread
Results 1 to 7 of 7

Help excel = identify the same even / odd pattern in the same position.

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

    Help excel = identify the same even / odd pattern in the same position.

    Help excel = identify the same even / odd pattern in the same position
    * From last to next
    Par = 0,2,4,6,8
    Odd = 1,3,5,7,9
    Example on pick3
    1st 2nd 3rd
    4 5 6
    9 0 2
    * In the third position it repeated the same pattern for 6 to 2 in the standard par = 0,2,4,6,8
    * Objective = to see which of the three positions repeats the pattern, is different from how the digit repeats

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

    Re: Help excel = identify the same even / odd pattern in the same position.

    https://www.excelforum.com/attachmen...1&d=1525607315
    always the last draw for the next
    Attached Files Attached Files

  3. #3
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2010
    Posts
    4,804

    Re: Help excel = identify the same even / odd pattern in the same position.

    Try this in E8:

    =IF(MOD(A7,2)=MOD(A8,2),"X","")

    Copy across and down.

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

    Re: Help excel = identify the same even / odd pattern in the same position.

    Ok.PHOUCAM,PLEASE! you can get on the worksheet? Every week I will put new pick3
    (raffles) the formula has to do automatic
    459
    159
    850
    753
    159
    ....

  5. #5
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    12,109

    Re: Help excel = identify the same even / odd pattern in the same position.

    I am guessing that you want the cells in columns E:G to remain blank until the new pick3 has been entered. If that is the case then modify Phoucam's formula to read:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Paste the formula into cell E8
    Copy across to G8
    While E8:G8 are still selected pull the fill handle down as far as necessary.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

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

    Re: Help excel = identify the same even / odd pattern in the same position.

    ok jeteMc , esta corret, conglatulations, thank you!

  7. #7
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    12,109

    Re: Help excel = identify the same even / odd pattern in the same position.

    You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.

+ 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. Identify by position the number of a draw list.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-09-2017, 04:51 AM
  2. Continuing a pattern on autofil without pattern re-starting
    By jakeyoung111 in forum Excel General
    Replies: 4
    Last Post: 06-22-2016, 11:11 AM
  3. [SOLVED] Lookup and return rows based on pattern start and pattern end
    By JDI in forum Excel General
    Replies: 18
    Last Post: 11-16-2014, 11:44 PM
  4. [SOLVED] How to identify a data pattern?
    By my_sunshine in forum Excel General
    Replies: 4
    Last Post: 01-06-2014, 11:27 PM
  5. Replies: 4
    Last Post: 01-04-2013, 02:21 PM
  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. identify is the pattern which gives the highest % success
    By censura in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-04-2007, 03:31 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