Data matching & appending in Excel or SQL
This project was successfully completed by ramyrafik for $10 AUD in a day.Get free quotes for a project like this
Project Budget$10 - $30 AUD
Completed In1 day
Small project- looking for bids of $10
Need someone to setup queries so a master list column is referred to and based on provided keywords (most with wild card front and back) append associated flaggings.
• % represents wild card. For example, sm%th finds "smith" and "smyth". Also %east finds "Northeast" and "Southeast"
• where % does not exist, there is no wild card
• space sensitive (Very Important)
• not case sensitive
• where there is more than one 'Job Folders' or 'Job Level' separate with ; in the same cell.
• conditions include where a keyword exists or where a keyword does not exist -append a code.
See attached for production file. Let me know if you have any questions.
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