View Single Post
 
Old 06-07-2014, 02:24 PM
Darkiness Darkiness is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Jun 2014
Posts: 5
Darkiness is on a distinguished road
Default Sorting a list of people by reference to another list

Hi
I'm a first time user on the forum. Nice to meet one and all.

I love using excel but only learn what I use.
My problem is this. I have a list of about 25000 people in rows with data name address tel number etc and also final column which is the local club they are in (or at least assigned to).
Problem is that we have about 350 clubs and we have just reorganised into districts across the country (7 of them)

I want to use excel to quickly sort people into districts based upon their club (rather than their home address) without doing it manually by comparing the membership list with the districts list of clubs.

Is there an easy way to do this?

Any help would be much appreciated.

D
Reply With Quote