Käynnissä

Locate New/Unique in one Excel file compared to another

Hi,

We have 2 Excel databases of clients, one for 2008 and the other for 2009.

We need someone to go through the 2009 file and copy out each client row for those that are new clients - that is, those that aren't in the 2008 version. These need to be copied into a new Excel file called 2009 New [url removed, login to view]

However, in 2008 there is a client for example called Wendouree Cellars (A.P. Birks) and for some reason in the 2009 file it is called Wendouree Cellars (AP Birks). There is a slight change here in the way the company name was input into the 2009 file, but it is not a new client, it is the same one. We need to make sure these type of things don't go into the new, unique client database, only the actual new ones (not typo's).

We also need to go through the 2009 file and copy out each client row for those that have a new contact person for that client - that is, those clients who existed in the 2008 file, but who now have a different contact person. These need to be copied into a new Excel file called 2009 New [url removed, login to view]

Again however, in 2008 there is that client for example called Wendouree Cellars (A.P. Birks) and for some reason in the 2009 file it is called Wendouree Cellars (AP Birks). There is a slight change here in the way the company name was input into the 2009 file, but it is not a new client, it is the same one. We need to check if there is new contacts for these clients who were there last year.

This is extremely urgent and needs to be done very quickly.

Taidot: tiedonsyöttö, tietojenkäsittely, Excel

Näytä lisää: we excel, version one, to p, new excel, urgent p, urgent need for excel, urgent excel, new company name, Locate, copy p, copy excel, ap, excel unique, excel contact file, excel copy data excel file, data entry copy xls, contacts database excel, data input xls, file name excel, excel check check, copy file name, excel check, excel database input, copy data excel file, xls excel data

About the Employer:
( 29 reviews ) Campbelltown, Australia

Projektin tunnus: #479808