Compare Data to find discrepancies

M

ModernGIS

Greetings,

I am building a new GIS system and use Microsoft Excel to prepare and
analyze data before it goes into different parts of the system. Some of the
data comes from a different company that I use to update our system on a
monthly basis.
What I need to be able to do is to take existing data from a previous
export and compare it with new data that will go back into the system. All
the data is linked via the Parcel ID #. Each one of the parcel ID #'s has (9)
pieces of data associated with it that I need to determine if changes are
happened. That pieces of data range from an owner name to the parcel land
size.
Thanks for any assistance anyone can offer on how to complete this.
 
L

Luke M

I'd take a look at the VLOOKUP and EXACT/MATCH functions. Should give you
some ideas on looking up data and comparing.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top