Data matching & appending in Excel or SQL
$10-30 AUD
Paid on delivery
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.
Notes:
• % 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.
Project ID: #5069879
About the project
Awarded to:
Hello I'm an excel formulas expert. I can help u with this very easily. I just want to know what u mean by "conditions include where a keyword exists or where a keyword does not exist -append a code. "
6 freelancers are bidding on average $22 for this job
Hi, I have wide experience in SQL and Excel. I have had a look into your excel, Please message me your exact needs. I would get the task done to you today under one hour or so.
Hi,. it seems your requirements to your project was fit to my qualifications. I can re design your excel template that would help you a lot more presentable.. Feel free to see my portfolio. And i will send you later a More
