1
Матвей
no recommendations
no complaints
Closed
Project title: Urgent assignment in excel for 1 hour of work
Type of cooperation: One-time project
Section: Other / Miscellaneous
Prepayment: prepayment is possible
Payment methods: Bank transfer
Acceptance of requests: closed
Type of cooperation: One-time project
Section: Other / Miscellaneous
Prepayment: prepayment is possible
Payment methods: Bank transfer
Acceptance of requests: closed
Project description:
For tables on the pages of Disassembly and Base of Pharmacies, install filters and fix the top line.
For each client on the Discussion page, find a match on the Pharmacy Database page, then copy Pharmacy ID, MD Pharm. Chain ID, MD Pharm.Chain Name of the necessary institution from the page of the Pharmacy Base and put in the appropriate column on the page Discussion. If there are comments on the found data - fill in the appropriate column Comments on the tab Discussion.
Add information on the availability of a contract with the network (Yes or NO). *In this task, it is recommended to use the VDP function (VLOOKUP). When using formulas, do not keep formulas as values.
For tables on the pages of Disassembly and Base of Pharmacies, install filters and fix the top line.
For each client on the Discussion page, find a match on the Pharmacy Database page, then copy Pharmacy ID, MD Pharm. Chain ID, MD Pharm.Chain Name of the necessary institution from the page of the Pharmacy Base and put in the appropriate column on the page Discussion. If there are comments on the found data - fill in the appropriate column Comments on the tab Discussion.
Add information on the availability of a contract with the network (Yes or NO). *In this task, it is recommended to use the VDP function (VLOOKUP). When using formulas, do not keep formulas as values.
