Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to sort random numbers in columns
I need to insert numbers out of order in columns, how can I sort them into
correct order in columns. |
#2
|
|||
|
|||
Select your range and do Data|sort???
(Not sure if I understood the real question, though.) webehere wrote: I need to insert numbers out of order in columns, how can I sort them into correct order in columns. -- Dave Peterson |
#3
|
|||
|
|||
That doesn't work. I have approx 5000 items to scan into a file, they are
numbered 1 thru 5000. i have to scan them out of order. I want to keep a list of scanned items in numerical order. but, I have to scan them at random. I need to enter the item number in random order and then sort it into ascending order and into columns for record keeping. I have been told that this can't be done. Surely it can. "Dave Peterson" wrote: Select your range and do Data|sort??? (Not sure if I understood the real question, though.) webehere wrote: I need to insert numbers out of order in columns, how can I sort them into correct order in columns. -- Dave Peterson |
#4
|
|||
|
|||
So you have the numbers 1-5000 in unsorted order. But you put these numbers
into different columns???? If that's what you meant, then you'll have to do some work. Put the data in one column and then sort that column. Then if you really need, separate the single column back into separate columns. David McRitchie has some code to put the data into separate columns at: http://www.mvps.org/dmcritchie/excel/snakecol.htm ====== An alternative. Use MSWord. It handles tables, columns and sorting the way you want. webehere wrote: That doesn't work. I have approx 5000 items to scan into a file, they are numbered 1 thru 5000. i have to scan them out of order. I want to keep a list of scanned items in numerical order. but, I have to scan them at random. I need to enter the item number in random order and then sort it into ascending order and into columns for record keeping. I have been told that this can't be done. Surely it can. "Dave Peterson" wrote: Select your range and do Data|sort??? (Not sure if I understood the real question, though.) webehere wrote: I need to insert numbers out of order in columns, how can I sort them into correct order in columns. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Randomly Sort a Series of Numbers | Excel Discussion (Misc queries) | |||
How do you find duplicate values in excel- 2 columns of numbers | Excel Discussion (Misc queries) | |||
two columns of numbers, need to sort/filter to find one number th. | Excel Discussion (Misc queries) | |||
How do I take two columns of sequential numbers and insert spaces | Excel Discussion (Misc queries) |