473,322 Members | 1,401 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Looking for a freeware that can put numbers in numerical order

I Looking for a freeware that can put numbers in numerical order? I could use excel but It make this for 3 lines each time, if I'd do in this way I'll take ad aeternum to finish the work. Is it avaliable a freeware, spreedsheet/vb/vba that do all the work at once??
I´d like to put large numbers sequence in ascending order(from the smallest to the greatest number) (from the left-to-right direction) for each sequence number line
I put an attachment as an example of large numbers list in order to try doing this
Cans someone could help me ???

Thanks in advance
Attached Files
File Type: zip egxp.zip (46.3 KB, 102 views)
Jul 15 '10 #1
3 1956
code green
1,726 Expert 1GB
Tutorial with examples http://www.vb6.us/tutorials/understa...basic-tutorial
Jul 16 '10 #2
Killer42
8,435 Expert 8TB
Please let us know how this works out for you. At a glance, the linked tutorial looks like a very useful one.
Jul 17 '10 #3
Guido Geurs
767 Expert 512MB
This macro will sort each row ascending (see also attachment)

Expand|Select|Wrap|Line Numbers
  1. Sub Sort_Numbers()
  2.    Range("A1").Activate
  3.    Do While ActiveCell.Value <> ""
  4.       Range(ActiveCell, ActiveCell.End(xlToRight)).Select
  5.       Selection.Sort Key1:=ActiveCell, Order1:=xlAscending, Header:=xlGuess, _
  6.          OrderCustom:=1, MatchCase:=False, Orientation:=xlLeftToRight, _
  7.          DataOption1:=xlSortNormal
  8.       ActiveCell.Offset(1, 0).Activate
  9.    Loop
  10. End Sub
Attached Files
File Type: zip egxp_v1.zip (80.7 KB, 93 views)
Jul 17 '10 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Help! | last post by:
Does any one knows out of the top of their heads if Windows has a command line or any numerical sorting utility -not alphabetical. I found some Java script that can do it,but want to make sure I am...
19
by: David | last post by:
Hi all, A while back I asked how to sort an array of strings which would have numerals and I wanted to put them in sequential numerical order. For example: myArray = "file1"; myArray =...
4
by: Deborah V. Gardner | last post by:
I have a field with values like this CO 03-10 CO 03-4 VI 03-8 CO 03-533 I would like these to sort for a report by the first two letters and the digits after the hyphen (-) like this
3
by: TituscroW | last post by:
Hello, This is my first post, so I hope I include all the right information. I have a Table which has a list of numbers stored in a string, which are not in numerical order For example "10 2 35...
0
by: iMonkey | last post by:
Hi, I have a drop down list which is populate through a database connection, the data that is retrieved is of Shoe sizes i.e. 3 - 12 when the drop list loads I nhave noticed that the list is in...
11
by: Leon | last post by:
I have six textbox controls on my webform that allows the user to enter any numbers from 1 to 25 in any order. However, I would like to sort those numbers from least to greatest before sending them...
7
by: Giles | last post by:
An ASP page outputs data from the query "Select ThisAndThat from comments WHERE pageURL='" & pageURL & "' ORDER BY threadID, datesent" (Access mdb) threadID is a string (OK, I know!), which means...
10
by: ckpoll2 | last post by:
Hello, I have a report that returns document numbers in the format "AA999999". These numbers are not in alphabetical and then numerical order. How can I put these in order? Thanks, Charlie
0
by: tiddwaylll | last post by:
Hi Hi, I am looking for a easy and free numerical library to implement. More important is to be free haha. The language/framework is in C#.NET. If you know of any, please point me in the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.