+ Reply to Thread
Results 1 to 16 of 16

generate threes with delta 2 value and also 3 between the trio from 01 to 25.

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

    generate threes with delta 2 value and also 3 between the trio from 01 to 25.

    generate threes with delta 2 value and also 3 between the trio from 01 to 25
    ex = 01 04 07 = delta value (or difference 3)
    another example = 19 22 25 = value delta = 2
    and also with delta value or difference = 3
    01 05 09 = delta 3
    18 21 25 = value 3
    * generate all suits or triples from 01 to 25
    with delta 2 value and also 3 please

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: generate threes with delta 2 value and also 3 between the trio from 01 to 25.

    Clear as mud...

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

    Re: generate threes with delta 2 value and also 3 between the trio from 01 to 25.

    hello, pepe, thanks for watching the post
    well, in the limit of 01 to 25 we have 2,300
    * trios, or triplets,
    but I want filtered where the difference between
    * the numbers are 2 and those with difference 3
    ex =
    02 03 05 = difference = 1,2 because 01 to 02 = and 1 and 03 to 05 = and 2 = this is not good
    * 02 05 08 = difference is 2
    * this serves
    * can you create the 2300 and filter by multiples of 2 and 3?

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

    Re: generate threes with delta 2 value and also 3 between the trio from 01 to 25.

    hello, please
    the macro will separate threes with a delta value of 2
    and of 3 of the list of 2300 trios

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

    Re: generate threes with delta 2 value and also 3 between the trio from 01 to 25.


  6. #6
    Registered User
    Join Date
    04-24-2017
    Location
    Portugal
    MS-Off Ver
    2016
    Posts
    27

    Re: generate threes with delta 2 value and also 3 between the trio from 01 to 25.

    I don't follow your logic.
    What is the objective?
    Can you explain what you need?

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

    Re: generate threes with delta 2 value and also 3 between the trio from 01 to 25.

    hello exnub, thanks for watching the post
    Well, we have the 2300
    * threes from 01 to 25
    the macro has separate trios where
    * must have the difference value of 2 and also 3
    look at this trio
    * 01 03 07 = difference 1 3 does not work
    01 04 07 = difference 2 and 2 yes it is ok

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

    Re: generate threes with delta 2 value and also 3 between the trio from 01 to 25.

    hello exnub, thanks for watching the post
    Well, we have the 2300
    * threes from 01 to 25
    the macro has separate trios where
    * must have the difference value of 2 and also 3
    look at this trio
    * 01 03 07 = difference 1 3 does not work
    01 04 07 = difference 2 and 2 yes it is ok

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

    Re: generate threes with delta 2 value and also 3 between the trio from 01 to 25.

    hello!!!separating trio whose distance between the numbers is 2 and also all trios
    * whose distance between the three numbers is 3
    Do you have the planilia, to separate

  10. #10
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: generate threes with delta 2 value and also 3 between the trio from 01 to 25.

    It looks like your spreadsheet has already generated all of the combinations of three from 1 to 20. You have highlighted two entries (row 53 and row 77) and added to row 53 2 -- 2 -- valor delta 2 and row 77 3 -- 3 -- valor delta 3. I am not sure what you are needing help with or what your question is, but it looks like you want to programatticly highlight/filter/extract these 2 rows (and other rows???) The only thing I see is:
    1) formula in D and E =B4-A4-1 entered into D4 and copied down and across into D and E.
    2) filter/conditional format/query to find all the entries where columns D and E are 2 or 3.

    Is it as simple as that, or is there more to your question?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

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

    Re: generate threes with delta 2 value and also 3 between the trio from 01 to 25.

    hello mrshorty, thanks for watching the post
    * yes you are correct
    * to separate the trios from the excel list
    * whose distance between the three numbers is 2 and also 3 of the other trios
    * because it is a standard that is being raffled 75% in lottery draws 25/15
    Do you want to download it?

  12. #12
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: generate threes with delta 2 value and also 3 between the trio from 01 to 25.

    If you have a file that will help us understand your question, then upload it to the forum so we can look at it. If I have understood correctly, then it should be as simple as adding those formulas and setting up the filter or query. I would tend to use Autofilter for the filter step, because it is easy to use: https://www.wikihow.com/Use-AutoFilter-in-MS-Excel

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

    Re: generate threes with delta 2 value and also 3 between the trio from 01 to 25.

    only threes with distances
    * 2, 2
    * and
    * 3, 3
    between the numbers
    * ex =
    2.2 = 01 04 07 (02 03) 2 (05 06) 2

    3.3 = 01 05 09

  14. #14
    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
    79,369

    Re: generate threes with delta 2 value and also 3 between the trio from 01 to 25.

    Jorel - please upload a workbook.
    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.

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

    Re: generate threes with delta 2 value and also 3 between the trio from 01 to 25.

    ok thank you a ALI
    https://www.excelforum.com/attachmen...1&d=1560614935
    Attached Files Attached Files

  16. #16
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: generate threes with delta 2 value and also 3 between the trio from 01 to 25.

    only threes with distances
    * 2, 2
    * and
    * 3, 3
    between the numbers
    * ex =
    2.2 = 01 04 07 (02 03) 2 (05 06) 2

    3.3 = 01 05 09
    I'm not sure what the question is. That should be a simple matter of setting the filter criteria. When you want to 2.2 sets, set the filter criteria (the dropdown on each column header in your first row of labels) so that column D is set to show only those with 2 and column E is also set to show only those with 2. If you are unfamiliar with how to use autofilter, review the tutorial (or any other tutorial that you find easier to follow -- a quick google search for "autofilter in Excel" should yield several tutorials).

+ 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. delta between two columns
    By activation01 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-01-2019, 12:48 PM
  2. [SOLVED] please, put the trio in ascending order .
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-20-2019, 04:41 PM
  3. Separating trios without repeating digits Determine the position of the trio
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-07-2017, 10:20 AM
  4. I want to find the closest point to the origin using delta X and Delta Y.
    By dcmapper in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-31-2016, 05:05 AM
  5. Finding a trio of numbers that appears most
    By bines in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-07-2015, 04:15 PM
  6. How do I count trio in excel?
    By rafa.jsilva in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-16-2010, 06:49 AM
  7. Delta
    By Shatin in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-15-2005, 04: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