Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-01-2017, 04:55 AM
Peace Freak Peace Freak is offline Sorting McC... before MAC Mac OS X Sorting McC... before MAC Office for Mac 2011
Novice
Sorting McC... before MAC
 
Join Date: Apr 2017
Posts: 5
Peace Freak is on a distinguished road
Default Sorting McC... before MAC

Hello!

I have created a booklist for a small school library that has about 1,600 books.

Using the sort function, I get this order for the family name:

MAYOROS
McCAFFERTY

The librarian has told me that McCAFFERTY should come before MAYLOROS because of its lower case c. I did a bit of checking on some library sites and found various "rules", depending on library and other things, too...



I'm wondering if it is possible to "tweak" the sort order in Excel, i.e., change the alphabetising rules, or are such things set in stone?

Thanks in advance!
Reply With Quote
  #2  
Old 10-04-2017, 02:59 PM
macropod's Avatar
macropod macropod is offline Sorting McC... before MAC Windows 7 64bit Sorting McC... before MAC Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Excel does not have a lexicographical sort function - which is what you are describing. You could, of course, edit the alphabetically-sorted data manually to apply the required lexicographical sorting.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting McC... before MAC Sorting gilmourlead Excel 3 02-17-2016 09:27 AM
Sorting McC... before MAC Sorting texascpa Excel 1 07-15-2015 12:22 AM
Sorting McC... before MAC Sorting Challenge gbaker Excel Programming 11 06-22-2012 09:39 AM
Sorting by certain criteria randenius Excel 2 06-11-2012 02:18 AM
Sorting McC... before MAC Need help in aplhabetica sorting brooklyn86 Word VBA 1 06-05-2012 11:43 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:17 AM.


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