Re-Arranging Numbers to be in Chronological Order

Hi Rlpowers,

The attached code should sort all values as you expect... I hope. There is a lot of code, so follow these instructions..

1. Open a copy of your workbook and press ALT+F11 to open the VB Editor. (In case something goes horribly wrong!)
2. Click Insert > Module
3. Open the attached text file and copy all of the code
4. Paste the code into that new module in the VB Editor
5. Close the VB Editor
6. Activate the sheet that contains the values you need sorted
7. Press ALT+F8 to open the Macros dialog
8. Select the "reorg" macro and click Run

I wrote the "reorg" macro, and the rest of the code ("QSortInPlace") is from Chip Pearson's site 'Sorting Arrays in VBA' here: http://www.cpearson.com/excel/SortingArrays.aspx

Hopefully this helps!

If the numbers in your string data are consistantly numerically descending then this UDF might help.

Please Login or Register  to view this content.

Enter in B1

Please Login or Register  to view this content.

Drag/Fill Down

[EDIT]
Second Loop removed. I've no idea why I thought it was needed, to much beer probably ...