IF YOU ARE A WIZ WITH MACROS OR EXCEL DATA COMPARISONS USING AUTOMATIC SEARCH FEATURES... YOU'LL BE PERFECT FOR THIS
We have 2 excel task and we need someone who can do the work within a couple hours.
We have one excel file with 270,000 records in it and another with about 12,000 records in it. We need to find the 12,000 in the file with the 270,000 and highlight them blue.
The data it is searching in the 12,000 excel file has records in about 10 columns that needs to be compared to one single column in the big 270k file.
Output will be an excel file with 270k records with 12,000 records highlighted blue to denote which came from the smaller list.
- We have an excel sheet that contains about 22,000 people
- We need to recategorise the people in the sheet by a number of "new" list names and create a different csv for each of the categories (about 10 categories)
- the 1st row must use specific field names (e.g. FIRST_NAME) so that it can be uploaded to our new system easily