Populate fields in an XLS sheet from a XML file (link below)
- or -
Post a project like this1318
£105(approx. $132)
- Posted:
- Proposals: 9
- Remote
- #2986029
- Awarded
Microsoft Certified Power BI Data Analyst & Advance Excel Specialist¦Professional Power BI consultant ¦ (ACCA)- Chartered Certified Accountant ¦ Accounting- Reconciliations ¦DAX ¦Data Models ¦
Doha
Virtual Assistant | Web Research Specialist | Excel | Fillable / Editable PDF |Data Mining Specialist |Data Extraction | & Project Coordinator
Cairo
970117323952524121140641617882902385436245492427272934755991
Description
Experience Level: Expert
Job 1: Populate Column C (Count) of the first tab in the attached excel file with a count of how many instances there are in the XML file where the value in the field contains all words from Column B (Clean Job Title) in any order.
Job 2: Populate Column A () of the second tab ( with Clean Matches) with the values from the field in all records in the XML file. Then, populate Columns B to K with Matches from Column B in the "Clean Job Title Count" Tab. A match is when all words (in any order) from a Clean Job Title record are contained within a record. Match 1 should contain the record with the most matching words, Match 2 the next, and so on. There may not always be 10 matching values.
http://xfer.allthetopbananas.com/feeds/bestjobsxmluk-feed.xml
Job 2: Populate Column A () of the second tab ( with Clean Matches) with the values from the field in all records in the XML file. Then, populate Columns B to K with Matches from Column B in the "Clean Job Title Count" Tab. A match is when all words (in any order) from a Clean Job Title record are contained within a record. Match 1 should contain the record with the most matching words, Match 2 the next, and so on. There may not always be 10 matching values.
http://xfer.allthetopbananas.com/feeds/bestjobsxmluk-feed.xml
Ray D.
100% (37)Projects Completed
26
Freelancers worked with
22
Projects awarded
45%
Last project
28 Nov 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies