+ Reply to Thread
Results 1 to 3 of 3

please, separate trios without repetition of digit.

  1. 02-21-2019, 05:44 AM #1
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    please, separate trios without repetition of digit.

    please, separate trios without repetition of digits ie there must be six different digits
    ex = 04 19 28 = we have 6 single digits
    14 15 23 = can not be repeated
    * separate all training with 6 different digits (without repetition).
    https://www.excelforum.com/attachmen...1&d=1550742268
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-21-2019, 04:12 PM #2
    mrice
    mrice is offline
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: please, separate trios without repetition of digit.

    Please see the attached, it uses a succession of formulae to zero - fill and concatenate and then to count the occurrences of each digit.
    Attached Files Attached Files
    Martin
    Reply With QuoteRegister To Reply
  3. 02-21-2019, 06:32 PM #3
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: please, separate trios without repetition of digit.

    hello,MRICE, perfect corret conglatulations, thank you
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Hello please, separate the strings from the initial digit.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-07-2018, 03:46 PM
  2. [SOLVED] Please separate the last digit, and add the quantity in each pattern
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-09-2018, 08:03 PM
  3. [SOLVED] Separate quartet formations without repetition of digits deleting duplicates .
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-01-2018, 04:26 PM
  4. [SOLVED] Separate triad formations without repetition of digits, *
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-05-2017, 08:15 AM
  5. [SOLVED] Macro to separate trios with different digits
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 05-22-2017, 10:15 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. Separate trios without repeating digits of a draw. Please Help, Urgent,
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-30-2014, 09:08 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1