LinkBack URL
About LinkBacks
please
ex= 000 000 000 000...
000
000
000
000
https://www.excelforum.com/attachmen...1&d=1509795251
please
ex= 000 000 000 000...
000
000
000
000
https://www.excelforum.com/attachmen...1&d=1509795251
And also delete blank lines, that is, join the columns in a single column, please
Hi jorel- This processes the active worksheet, condensing all rows into a single uninterrupted column of values.
Original cells are erased; output is placed in column A.
Please Login or Register to view this content.
Last edited by leelnich; 11-04-2017 at 10:36 AM.
Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee
Hello, the correct one is a column but with three numbers
Have to stay like this
You have to stay in a column but in 3 numbers
00 00 00 corret
00 00 00
00 00 00
.....
00
00 error
00
corret
00 00 00
00 00 00
00 00 00
00 00 00
....
hello, leelnich
corret is
00 00 00
00 00 00
00 00 00
.......
Sorry, I have to go to work. I'll try to pick this up later...
ok, colunn
00 00 00
00 00 00
....
hello, please
It looks like you attached a workbook with 4500 rows of data that is not near anything like your post 1.
At least I can't make head or tails out of it.
Need a better explanation or preferably a representative attachment with a before and after and an explanation how you arrived at the result.
Hello, joliva, I just need you to organize in a single column of three numbers
* 000
000
.. in .txt in two houses 00 00 00
* For another solft read, but you need to organize only one column !! please
hello LEELNICH, PLEASE
For Each c In .Columns(3).Cells
inArray = Range(c, c.End(xlToRight)).Value
For i = 1 To UBound(inArray, 2)
outArray((count + i), 1) = inArray(1, 1) error
Next
count = count + i - 3
Next
hello leel. please!
Sorry, I had a busy weekend. This reads each constant on the active sheet (left to right, top to bottom) and returns them to a new sheet in 3-column groups.Please Login or Register to view this content.
Last edited by leelnich; 11-07-2017 at 01:03 PM. Reason: Order of output corrected
Originally Posted by jorel
Please remember that those who help here do so voluntarily and of their own goodwill.
They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe.
This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'.
Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it.
Thanks for your understanding and patience.
Ohh, ok perfect, very good work leelnich, congratulations, conglatulations
* thank you
Please see post#15 for updated code. (Order of output has been corrected)
Here's an alternative. Output "oo oo oo" to 1 column (instead of 3) on a new sheet:Please Login or Register to view this content.
Last edited by leelnich; 11-07-2017 at 01:06 PM.
Hello, ok both conditions are working pretty good job
Leel, I have in the other topic is about doubles with repetition of digits to exclude
Can you see this in the other post?
Thank you leel = conglatutualtions
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks