+ Reply to Thread
Results 1 to 22 of 22

All odd and even digit formations

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

    All odd and even digit formations

    All odd and even digit formations
    In pick3.
    Hello, I need help on excel 2010 or higher Windows 7.
    Then we have even numbers = 0,2,4,6,8 odd digits 1,3,5,7,9
    All formations that have odd digits of 000 to 999
    Example = 135,197 ..... all from 000 to 999
    All formations of even numbers = 246, 284 842 ...... all from 000 to 999
    All formations that have two even and an even number
    Example = 423 865 429 ....
    All formations that have two odd digits and a pair of 000 to 999
    Ex = 158, 794 138
    We then have 4 lists to generate from 000 to 999
    Please

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

    Re: All odd and even digit formations

    hello please!!!

  3. #3
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    575

    Re: All odd and even digit formations

    I don't think anyone has any clue what you want. Try Google translate.

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

    Re: All odd and even digit formations

    There are 1000 (thousand) training from 000 to 999 ok!
    We have 4 possible groups
    Where two digits are even and and the other two digits are odd and and where 3 digits are odd and another 3 digits are even. is easy

  5. #5
    Forum Contributor
    Join Date
    08-04-2004
    Location
    Amsterdam
    MS-Off Ver
    2016
    Posts
    186

    Re: All odd and even digit formations

    Upload an example with expected outcomes

  6. #6
    Forum Contributor
    Join Date
    08-04-2004
    Location
    Amsterdam
    MS-Off Ver
    2016
    Posts
    186

    Re: All odd and even digit formations

    Ok.I think I understand. For all numbers from 000-999 you want a separate list that lists:
    1. All even 3 digit numbers
    2. All odd 3 digit numbers
    3. All 3 digit numbers that contain 2 individual odd numbers
    4 All 3 digit numbers that contain 2 individual even numbers

    Is that right?
    What about numbers like 111 or 222?
    Last edited by philaugust2004; 03-27-2017 at 11:38 AM.

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

    Re: All odd and even digit formations

    Hello phila yes, yes!!! this statement is correct
    About 111 and 222
    The pick3 111 belongs to the groups all three odd digits we have
    111,333,555,777,999
    The pick 3 = 222 belongs to the group of pairs 222,444,666,888,000
    Is easy
    1st group of pairs = 222,444,666,888,000, 428 840 624 ....
    2nd group only odd = 111,333,555,777,999, 159,357,195 ...
    3rd two-digit even 241 847 621 520
    Fourth two odd digits = 158 370 198 ...

  8. #8
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: All odd and even digit formations

    A
    B
    C
    1
    Number
    # Odd
    2
    000
    0
    B2: =SUMPRODUCT(MOD(MID(A2,{1,2,3},1),2))
    3
    001
    1
    4
    002
    0
    5
    003
    1
    6
    004
    0
    7
    005
    1
    8
    006
    0
    9
    007
    1
    10
    008
    0
    11
    009
    1
    12
    010
    1
    13
    011
    2
    14
    012
    1
    15
    013
    2
    16
    014
    1
    17
    015
    2
    18
    016
    1
    19
    017
    2
    20
    018
    1
    21
    019
    2
    22
    020
    0

    Then sort by col B.
    Entia non sunt multiplicanda sine necessitate

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

    Re: All odd and even digit formations

    Ok SHG but it goes up to 999 or up to 1000 (thousand)
    And the 4th group only two odd is missing? Example
    159, 397 .......
    Then the thousand pick3 was divided into 4 groups
    So odd = 973 ..
    Only pairs = 248 ..
    Two odd-numbered 138
    Two even numbers = 027
    In your the show is missing the only odd group
    Ex 159

  10. #10
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: All odd and even digit formations

    Pardon??

    See attached.
    Attached Files Attached Files

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

    Re: All odd and even digit formations

    Hello, SHG perfect, conglatulations, now separate each group into a column
    0 1 2 3

  12. #12
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: All odd and even digit formations

    I think you can handle that part, right?

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

    Re: All odd and even digit formations

    yes! I can!SHG!!!AHH! Precise in the formations of two pairs one odd and two odd, locate by position, that is to locate the doubles
    Both pairs and odd pairs
    Locate in positions 1 st, 2 nd, 1 rd and 3 rd
    Example 916 double 91 is in the 1st position
    961 this 1ª 3ª 691 this in the position 2ª 3ª
    To locate the pair both odd and even in their position
    Purpose is to filter by position
    The training is even and odd does not enter the study
    Use only the two-odd and odd-two formations, because of the double















    yes! I can! Precise in the formations of two pairs one odd and two odd, locate by position, that is to locate the doubles
    Both pairs and odd pairs
    Locate in positions 1 st, 2 nd, 1 rd and 3 rd
    Example 916 double 91 is in the 1st position
    961 this 1ª 3ª 691 this in the position 2ª 3ª
    To locate the pair both odd and even in their position
    Purpose is to filter by position
    The training is even and odd does not enter the study
    Use only the two-odd and odd-two formations, because of the double

  14. #14
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: All odd and even digit formations

    Is that a question or a statement?

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

    Re: All odd and even digit formations

    hello SGH Is a question about how we can find the pairs of odd and even pairs in the three positions and put the three positions in a heading to see each position vertically

  16. #16
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    575

    Re: All odd and even digit formations

    Is this a homework assignment?

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

    Re: All odd and even digit formations

    Hello, the bjetivo is to locate in the three position positions in 100%
    The pairs and odd doubles
    Example =
    596 = Odd double 59 is in 1st position
    Another example = 692 double pair 62 is in the 1st position 3rd
    You can create three topics of 1st and 2nd positions another topic of the 1st and 3rd positions and another one of the 2nd and 3rd positions
    Objective is to positionally locate the doubles of both the even and the odd-numbered digits are not taken into account
    Xox xox oxx

  18. #18
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: All odd and even digit formations

    A
    B
    C
    D
    1
    2
    222
    0
    All even B2: =SUMPRODUCT(MOD(MID(A2,{1,2,3}, 1), 2), {4,2,1})
    3
    223
    1
    Even first pair
    4
    232
    2
    Even outside pair
    5
    233
    3
    Odd second pair
    6
    322
    4
    Even second pair
    7
    323
    5
    Odd outside pair
    8
    332
    6
    Odd first pair
    9
    333
    7
    All odd

  19. #19
    Forum Contributor
    Join Date
    08-04-2004
    Location
    Amsterdam
    MS-Off Ver
    2016
    Posts
    186

    Re: All odd and even digit formations

    This will list even numbers if numbers are in A
    =IF(MOD(A1,2)=0,A1,"")

    and this will list odd
    =IF(MOD(A1,2)=1,A1,"")

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

    Re: All odd and even digit formations

    Hello, SHG, almost there, you can only work with two group group 1 and group 2
    The groups 0.3 does not enter the study ok.
    You create this positional header
    1ª 2ª x 1ª x 3ª x 2ª 3ª
    No (x) is the third digit, which asks for the 3 positions of the odd and even pairs
    Goal = do not play in the same position as the last draw for the next
    Example =
    Last draw = = double odd 15 on the 1st and 2nd
    In the next gave 259 gave in the position 2ª 3ª
    There was no repetition of the positions from the last to the next draw and this is the objective of the filter
    Only using the 1,2 groups (which have odd and even doubles is logical)
    Each pick3 generates three positional pairs
    Xox xox oxx
    Where (xx) is the odd pair and the pair pair

  21. #21
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: All odd and even digit formations

    Sorry, I don't follow any of that. You might have more success posting in your native language in the non-English forum.

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

    Re: All odd and even digit formations

    Ok ! sgh thank you man!!

+ 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] Formations in sequences of 3,4,5,6,7,8, all possible 01-25
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-26-2016, 01:26 PM
  2. separate formations with duplicate digits, please
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-25-2016, 05:08 PM
  3. 15 formations ( e) x (0)
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-30-2015, 12:45 PM
  4. how many formations is possible by selecting a digit * to pik3
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-01-2015, 12:05 PM
  5. Formations of 6 digits in ascending order
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-28-2014, 02:11 PM
  6. separate possible triple digit formations without repetition of 60/6
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-17-2014, 12:02 PM
  7. [SOLVED] LOTTERY FILTER#4, Find if 1 Digit Sum of 2 Digit or 3 Digit, Single Cell w/ dash
    By david gonzalez in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-08-2014, 12:57 AM

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