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.
|