Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-10-2021, 10:21 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: 551
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default Sort alphanumeric data using SORTBY

Hi. The SORTBY formula sorted the data in a column as follows:

GLUE, all purpose, 130 grams
GLUE, all purpose, 200 grams
GLUE, all purpose, 40 grams

I would like the sort result to be:

GLUE, all purpose, 40 grams
GLUE, all purpose, 130 grams
GLUE, all purpose, 200 grams



The usual help would be much appreciated. Thank you.
Attached Files
File Type: xlsx SortByAlphanumeric.xlsx (15.3 KB, 12 views)
Reply With Quote
 



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 04:35 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