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|
+----------------------------------------------------------------+
 
Back
Top