Help with Data sorting - macro?

  • Thread starter Thread starter rine9558
  • Start date Start date
R

rine9558

I have a block of cells that contain a number or a character or nothing.
I would like to select the cells and organize the numbers into
columns, ignoring the characters. Not all of the rows contain all the
numbers so when a row doesn't have a number the cell in that column
should be blank.
The numbers change each time. Is there a "straighten data" macro out
there somewhere?
Thanks,
Chuck
 
Chuck
Your message is unclear. Post an example of the data before and the
final result you are trying to achieve

DavidP
 
Attached is an example of the data sorting I am trying to accomplish.
The actual data are large (100x1000) and the numbers are not always in
ascending/descending order (although most of the time they are).
Thanks for any help,
CHUCK


+----------------------------------------------------------------+
| Attachment filename: example.xls |
|Download attachment: http://www.excelforum.com/attachment.php?postid=354311|
+----------------------------------------------------------------+
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with data sorting - macro? 5
Sorting by rows with differing numbers of cell entries 3
Data sort seperate by blank row 1
Macro to Sort A-Z a variable range of cells 1
Macro to sum doesn't work 2
Copy data from unlocked cells 3
Sort / Copy Macro 2
macro ignore formulas 3

Back
Top