View Single Post
 
Old 06-07-2014, 04:35 PM
whatsup whatsup is offline Windows 7 64bit 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