View Single Post
 
Old 08-24-2016, 04:33 PM
roderh roderh is offline Windows 7 64bit Office 2010 32bit
Novice
 
Join Date: May 2014
Posts: 17
roderh is on a distinguished road
Default Sorting page-numbers with ranges (i.e.: 6ff or 7-10 etc.)

Hi,

I have a excel-file with rows of unsorted page-numbers from a book.

After I select a couple of rows I would like to sort them.

Problem is: there are page-ranges like "14f" or "17ff" or "1141-1432". The excel build-in function cannot do this. I would think this requires VBA, but I cant do it myself.

I have attached two screenshots: first is the unsorted input, second is the desired output.
I have attached a excel-file, too. Desired output is in Worksheet 2. Please note, that the output should be in fact in worksheet 1 (i.e. output should replace the unsorted input), not in worksheet 2.

Thank you very much in advance for your help!
Attached Images
File Type: jpg Input unsort.jpg (20.0 KB, 26 views)
File Type: jpg output sorted.jpg (17.0 KB, 24 views)
Attached Files
File Type: xlsm Example Sorting.xlsm (10.6 KB, 11 views)
Reply With Quote