Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 04-13-2021, 04:08 PM
Marcia's Avatar
Marcia Marcia is offline Sort alphanumeric data using SORTBY Windows 7 32bit Sort alphanumeric data using SORTBY Office 2013
Expert
Sort alphanumeric data using SORTBY
 
Join Date: May 2018
Location: Philippines
Posts: 553
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Your are right, it is a struggle. I tried adding helper columns for size and measurement (mm, ml, g..) but still 23/13 came before 23/6 or 23/06 so the helper columns were discarded. I guess we will have to live with the not so perfect sort results.
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sort alphanumeric data using SORTBY Sort data by month and by dates Marcia Excel 4 05-30-2018 01:51 AM
Sort alphanumeric data using SORTBY Please Help. I need to sort Data A-Z not sure if i need to use Macros steveyjohn Excel 1 11-14-2014 06:19 PM
Sort alphanumeric data using SORTBY When I sort my data, the sumif report changes amaka Excel 6 03-19-2014 04:55 AM
sort data in excel cabot Excel 1 08-17-2012 09:41 AM
Sort alphanumeric data using SORTBY Sort Data rkeles Excel 6 02-04-2012 01:31 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:27 AM.


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