Adding a field for county in a table of address info

[Michael Morin]

I want to add a county column in a table with address information. I have a
list of towns for each county but I am not sure how to best indicate which
county that town is included in. I have a list of 700 or so addresses so I
don't have time to just type in county info for each address.

 

[Bernard Liengme]

You could use a lookup table but, as this seems to be a one-time project,
the work making the table might be more than just typing. Remember that once
you have a county in your new column you will not need to type its name
every time as Excel auto-complete feature should take over. I think I would
be tempted to sort by town - it might save some 'thinking' time.
best wishes

 

[Bill Ridgeway]

I want to add a county column in a table with address information. I have
a list of towns for each county but I am not sure how to best indicate
which county that town is included in. I have a list of 700 or so
addresses so I don't have time to just type in county info for each
address.

The Royal mail requirement for a County name to be included in (many but not
all) address went some years ago. Counties (as I and many people knew them)
disappeared in 1974 (England & Wales) and 1975 (Scotland). Since then
counties have been created in England and practically the whole of Scotland
and Wales and some have since disappeared (e.g. Avon) and Unitary
Authorities have appeared. If the Royal Mail doesn't require counties
included in the address I would suggest you save yourself the bother. I
think the only exception would be if you don't have a PostCode for a Post
Town name which is duplicated (e.g. Newport) - but finding PostCodes should
be very easy.

If you really have to add counties the only way is to go to the pre 1974
when it was 'stable' as since then there is a mish-mash of old counties, new
names, changed names and changed borders to contend with.

Bill Ridgeway

 

[Michael Morin]

I have already received a table in an XLSX file. It is already set up. The
reason why I want to add a county column is to be able to crunch numbers of
how many people live in which counties, etc.

 

[Michael Morin]

In the U.S., we still have counties and it is involved in state government.