This week I have received an excel spreadsheet of all the phone numbers from our MSAG provider. We can request one of these once a year for free. Each phone number has an address attached to it. Here are the steps I came up with to compare it to our GIS address point layer.
1) Create a field in the phone number spreadsheet called FULL ADDRESS.
2) Use the excel concatenate function to populate the FULL ADDRESS field. Don't forget to include TRIM to remove extra spaces.The function will look similar to this: =TRIM(CONCATENATE(B2," ",C2," ",D2," ",E2," ",F2))
3) Now you will have a field that shows the full address that looks like this: 4660 N HIGHWAY 1 PALM SHORES
4) Select the FULL ADDRESS column, go to DATA on the ribbon and click "Remove Duplicates". In the window click on Expand the selection and then only put a check mark in your FULL ADDRESS field.
5) This leaves us with all unique address values in the phone number list.
6) Export your Address Point GIS data in to an excel spreadsheet.
7) If you dont have a FULL ADDRESS field in your GIS data yet, create it in your Excel spreadsheet just like in step 2. IMPORTANT it needs to have the same name as in your MSAG spreadsheet.
8)Go to your MSAG spreadsheet and copy the FULL ADDRESS coulumn.
9) Go to your GIS spreadsheet and go to the last entry in your FULL ADDRESS column. Below this entry paste wha you have copied from your MSAG spreadsheet.
10) Now repeat step 4, which should eliminate all MSAG addresses that you have in GIS.
11) Anything below the last GIS entry will be addresses that you are missing in your GIS address point layer.
Hope this helps!
Tim