I work for a local UK council, and am trying to record responses to a
government campaign.

My town is divided up into 16 "wards" and a total of 3300 postcodes,
formatted like "BH11 8HU". I have a list in alphanumeric order of these
postcodes with their ward recorded as well.

On a seperate sheet I have a list of addresses, including postcodes, of
respondents. How would I best go about automating a search down the
respondents and counting them against their ward?

Thanks in advance.

Steve