+ Reply to Thread
Results 1 to 18 of 18

separating doubles according to the value of distances between two numbers,

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

    separating doubles according to the value of distances between two numbers,

    separating doubles according to the value of distances between two numbers, we have distances of the doubles of 1,2,3,4,5
    https://www.excelforum.com/attachmen...1&d=1524520016
    Attached Files Attached Files

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,605

    Re: separating doubles according to the value of distances between two numbers,

    Use such code:
    Please Login or Register  to view this content.
    Best Regards,

    Kaper

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

    Re: separating doubles according to the value of distances between two numbers,

    HellO KAPER huuu! Spectacular, very good job, now I need
    * That converts into two houses.txt (00) the doubles of each distance
    * I have a program that only reads in .txt (00) to be able to use the doubles for analysis
    In (00)
    You can put the 5 distant lists next in .txt (00) please

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: separating doubles according to the value of distances between two numbers,

    ...or as a UDF

    Please Login or Register  to view this content.
    e.g.

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    copied across and down

    =
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  5. #5
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: separating doubles according to the value of distances between two numbers,

    Quote Originally Posted by jorel View Post
    HellO KAPER huuu! Spectacular, very good job, now I need
    * That converts into two houses.txt (00) the doubles of each distance
    * I have a program that only reads in .txt (00) to be able to use the doubles for analysis
    In (00)
    You can put the 5 distant lists next in .txt (00) please
    I think you'll need to give some examples of what you mean. It's not at all clear - at least to me.

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

    Re: separating doubles according to the value of distances between two numbers,

    hello ,RICHARD,
    ex=
    03 04, 12 13, 36 37 18 20, 20 22, 26 28 convert . txt( 00) 03 04
    12 13
    36 37
    ....
    24 25, 39 40 02 04, 17 19
    06 08, 08 10, 24 26, 26 28, 35 37
    24 25, 39 40
    12 13, 33 34 02 04, 20 22
    03 04, 24 25, 36 37 11 13
    18 19, 30 31, 36 37 12 14, 23 25
    12 13 05 07, 17 19, 32 34, 38 40
    12 13, 27 28, 36 37 06 08
    09 10, 33 34 24 26, 26 28
    36 37 02 04, 17 19, 23 25
    12 13, 18 19, 30 31 39 41
    24 25, 30 31, 36 37 05 07
    03 04, 15 16, 36 37 27 29

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

    Re: separating doubles according to the value of distances between two numbers,

    Richard, Align in .txt columns (00 00)
    to export note pad because my program only recognizes (00) in .txt for later analysis of statistics
    all 5 columns
    00 00
    00 00
    00 00
    00 00
    ....

  8. #8
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: separating doubles according to the value of distances between two numbers,

    Can you upload an example of the results you expect in an actual workbook. Show the input somewhere and then manually add the results you expect in the position you want them. I'll find that easier to understand and avoids me having to misinterpret what you show.

    That may of course mean that a UDF is not the way to go since it returns a value in one cell rather than many cells
    Last edited by Richard Buttrey; 04-24-2018 at 09:15 AM.

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

    Re: separating doubles according to the value of distances between two numbers,

    ok macro separated several doubles at each distances, which has arrange in a column
    * in .txt ((00 00)
    00 00
    00 00

  10. #10
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: separating doubles according to the value of distances between two numbers,

    ...sorry, but as I said I would like to see EXACTLY what you want to see IN the WORKBOOK.

    It's too easy to misinterpret these things.

    You haven't said but what do you do once you have the results. Are you for instance wanting to generate a csv file or perhaps a .txt file?

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

    Re: separating doubles according to the value of distances between two numbers,

    Yes,yes!richard I need the file with termination.
    * .txt two houses (00 00) align one column
    * I have a program that can only process
    * in .txt (00) needs to convert to (00 .00) .txt
    draw stroke 14-28 = leave 14 28

  12. #12
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,605

    Re: separating doubles according to the value of distances between two numbers,

    1) Why you ignore kind requests? like the one from Richard concerning sample file

    2) Try modified code:
    Please Login or Register  to view this content.
    No, it is not exporting data into txt - you have to do it by yourself. Feel free to start new thread about it.
    As you have not attached sample I can only guess that the output is right. So do not want to loose time for preparing code for txt file(s) output of possibly wrong data.

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

    Re: separating doubles according to the value of distances between two numbers,

    Ok kaper, sorry, but I ask you to leave messages in a list in txt (00)
    Ok now this is correct, now I can put in the solft to process the analyzes of frequencies and delays of each pair, now this perfect, alias can always put
    * In .txt (00) for my program to be able to process, very good job KAPER!
    * When you win you will be rewarded # thanks

  14. #14
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: separating doubles according to the value of distances between two numbers,

    Quote Originally Posted by jorel View Post
    Yes,yes!richard I need the file with termination.
    * .txt two houses (00 00) align one column
    * I have a program that can only process
    * in .txt (00) needs to convert to (00 .00) .txt
    draw stroke 14-28 = leave 14 28
    Really, how difficult is it to upload a workbook as asked?
    We're here to help you but non of us like wasting time when it's so easily avoided.

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

    Re: separating doubles according to the value of distances between two numbers,

    hello, richard not avoided, it's like this
    What do you think of planning, but I tried to explain by message in no way was avoided

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

    Re: separating doubles according to the value of distances between two numbers,

    hello not avoided, it's like this
    What do you think of planning, but I tried to explain by message in no way was avoided

  17. #17
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: separating doubles according to the value of distances between two numbers,

    Quote Originally Posted by jorel View Post
    hello not avoided, it's like this
    What do you think of planning, but I tried to explain by message in no way was avoided
    Didn't you just say that?
    Sorry, you've completely lost me..

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

    Re: separating doubles according to the value of distances between two numbers,

    Richard, I could not mount the worksheet, okay, so I showed the posts in the post. Sorry
    was not avoided

+ 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] remove duplicate digits of numbers doubles list
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-17-2016, 05:33 PM
  2. Replies: 4
    Last Post: 02-04-2012, 01:46 PM
  3. [SOLVED] Separating Numbers
    By Himu in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-06-2005, 01:05 AM
  4. [SOLVED] Separating Numbers
    By Himu in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-06-2005, 12:05 AM
  5. [SOLVED] Separating Numbers
    By Himu in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-05-2005, 11:05 PM
  6. Separating Numbers
    By Himu in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-05-2005, 10:05 PM
  7. [SOLVED] Separating Numbers
    By Himu in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-02-2005, 01:05 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