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
|