Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-24-2016, 04:33 PM
roderh roderh is offline Sorting page-numbers with ranges (i.e.: 6ff or 7-10 etc.) Windows 7 64bit Sorting page-numbers with ranges (i.e.: 6ff or 7-10 etc.) Office 2010 32bit
Novice
Sorting page-numbers with ranges (i.e.: 6ff or 7-10 etc.)
 
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
 

Tags
excel vba macro sorting



Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting page-numbers with ranges (i.e.: 6ff or 7-10 etc.) Take String of numbers, expand ranges, sort, then compress back into ranges AustinBrister Word VBA 19 08-22-2016 05:18 PM
Sorting Numbers in a Document rsrasc Word VBA 3 01-04-2016 11:47 PM
Sorting Index According to Page Numbers mohsen.amiri Word 14 06-25-2015 09:50 PM
Sorting page-numbers with ranges (i.e.: 6ff or 7-10 etc.) Sorting paragraph numbers CommDude Excel 1 01-02-2011 04:38 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:57 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft