Automate comparison of data
This project was successfully completed by deepbluetech for $50 USD in a day.Get free quotes for a project like this
Project Budget$30 - $250 USD
Completed In1 day
I have an MS Excel file with 6 columns of data. The data in columns A and B are the material ID and material description respectively of project A, the data in column C and D are the material ID and material description respectively of project B while the data in column E and F are the material ID and material description respectively of project C. The objective of this assignment is to:
(a) put material ID which are common to 2 or more projects on the same row
(b) the rows corresponding to material ID which a project does not have but another project(s) has will be left blank
(c) all material ID runs in sequential order
It would be preferred if you are able to use VBA macro to automate the output of this assignment as the output is needed within a short time.
The MS Excel file with the 6 columns of data which you need to work on in order to deliver the objectives of this assignment (a) - (c) as above is the attached file named "Freelancer - Material ID and Material Description". A sample of the expected output of this assignment is in the attached file named "Freelancer - Sample Output".
Browse Related Skills
Other things people do on Freelancer
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online