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
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
Use such code:
Please Login or Register to view this content.
Best Regards,
Kaper
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
...or as a UDF
e.g.Please Login or Register to view this content.
Formula: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.
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
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
....
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.
ok macro separated several doubles at each distances, which has arrange in a column
* in .txt ((00 00)
00 00
00 00
...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?
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
1) Why you ignore kind requests? like the one from Richard concerning sample file
2) Try modified code:
No, it is not exporting data into txt - you have to do it by yourself. Feel free to start new thread about it.Please Login or Register to view this content.
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.
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
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
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
Richard, I could not mount the worksheet, okay, so I showed the posts in the post. Sorry
was not avoided
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks