+ Reply to Thread
Results 1 to 7 of 7

join the draw lines two by two creating a line in the union of each two different drawings

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

    join the draw lines two by two creating a line in the union of each two different drawings

    join the draw lines two by two
    creating a line in the union of each two different drawings without repetitions,
    * then separate the last digit in pairs
    to detect in the ten consecutive pars
    * objective = is to detect doubles of the last digit
    * consecutive, please
    https://www.excelforum.com/attachmen...1&d=1588734203
    Attached Files Attached Files

  2. #2
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,182

    Re: join the draw lines two by two creating a line in the union of each two different draw

    It's not clear to me how you get from this:

    11 13 14 16 18 20 23 24 25
    11 12 13 15 16 19 20 23 24

    To this:

    01 02 03 04 05 06 07 09 10 11 12 13 14 15 16 18 19 20 23 24

    Can you explain?

    WBD
    Office 365 on Windows 11, looking for rep!

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

    Re: join the draw lines two by two creating a line in the union of each two different draw

    hello, WIDE BOY thanks for viewing the post,
    well, the one on the left is from the draw lottery
    from 25/15, my lottery has 01 to 25 numbers where 15 numbers are drawn, the list where there are colors
    * yellow, blue, green ..... are the draw lines
    * my goal, is to join two in two lines, forming a line of 20,21,22, ... numbers without repetitions or distinct, then in each two draw lines a line will be created without the repetitions,
    then separate the last digit in pairs, then detect in the table of 10 consecutive pairs,
    * objective is to locate pairs of the last digits in consecutive pairs.

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

    Re: join the draw lines two by two creating a line in the union of each two different draw

    hello please!!!

  5. #5
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,182

    Re: join the draw lines two by two creating a line in the union of each two different draw

    I had to re-organize your sheet a little. See attached with macro.

    WBD
    Attached Files Attached Files

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

    Re: join the draw lines two by two creating a line in the union of each two different draw

    hello WIDE,excel error
    hello, there is a problem in excel when you will open excel. excel is
    locking, in other worksheets excel works, there is something in the worksheet that excel locks, you can see this

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

    Re: join the draw lines two by two creating a line in the union of each two different draw

    ok, wide,SORRY IS CORRET, THANK YOU!

+ 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] The UNION method cannot join ranges from different sheets
    By billj in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-28-2018, 07:17 PM
  2. creating line graph with multiple lines
    By elchenuk in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-31-2017, 08:44 AM
  3. Creating line graph with two lines.
    By snowdragon in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-13-2016, 10:03 AM
  4. Hi need help to draw a line chart having two lines of data
    By Sabyasachi_Samal in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 08-11-2016, 04:24 PM
  5. Query Join / Union
    By ciprian in forum Access Tables & Databases
    Replies: 26
    Last Post: 09-14-2011, 01:36 PM
  6. Union not creating a continuous line graph
    By DandT in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-11-2010, 02:01 PM
  7. Union, intersection, join
    By swchee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-28-2005, 12: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