Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 06-07-2014, 04:35 PM
whatsup whatsup is offline Sorting a list of people by reference to another list Windows 7 64bit Sorting a list of people by reference to another list Office 2010 32bit
Competent Performer
 
Join Date: May 2014
Posts: 137
whatsup will become famous soon enough
Default

Hi

Use a further column to establish the sort order by formula: Let's say starting in A2
A2 is the name of member
B2 the district
C2 the club
Then
D2 = B2&C2&A2

Copy the cells formula until the end of the list, and afterwards select the cell D2. Click Sorting ascending or - descending.
Before sorting make sure that no empty column/row seperates your list. As always give it a try on a copy of the origin.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting a list of people by reference to another list How to import list from Excel into drop-down list into word ahw Word VBA 43 02-28-2020 08:11 PM
Sorting a list of people by reference to another list List Style Numbering picks up out of order number from LATER list spthomas Word 12 12-16-2013 05:23 PM
Creating a list and sorting alphabetically. irvsax Word 4 09-04-2013 11:47 PM
Sorting a list of people by reference to another list Sorting numerically in recipient list greengauge Mail Merge 2 05-19-2013 09:58 AM
Need to delete 'field code changed' in my reference list leb Word 4 05-04-2013 12:25 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:44 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