Writing, improving the Excel program to compare product prices

Desktop Apps — incorrectly specified categories?

4 USD

Client's review of cooperation with Ilya Kulpin

Writing, improving the Excel program to compare product prices

4 USD

Everything is great, done precisely.

5.0

Igor Aleksandrovich

Reciprocal Feedback

15 June 2021

Freelancer's review of cooperation with Igor Aleksandrovich

Writing, improving the Excel program to compare product prices

4 USD

Periodically there were requirements for small improvements that were not agreed before. The project was long since. The client is constantly unconnected - appeared, and immediately disappeared. He responds to questions for a long time. What could be done in a few days eventually dropped out in a few months.

2.5

Ilya Kulpin

Reciprocal Feedback

15 June 2021

Project translated automatically. Log in or register, to view the original Hello to you.In the already finished Excel work programme for the price comparison of goods, you need to complete the functions: 1 .Select only one minimum value by indicating it in a specific column of the supplier U:AD by columns I:R, ignoring the other doubles.The formula =ESLI(M16="";"";ESLI(M16=NUMBER($I16:$R16;1);M16;"")) does not work because the value of M16 = the minimum value of W16.2ndAdd an account form, a commercial Word proposal to Excel by sample to a client list without a ds, a clen with a ds.The template of the Word form with the upper and lower column, formatted fields for entering the data of the buyer, account No, type of technique, page numeration.2.1 Set in Excel: automatic display of the order number account No date of creation of the document from .. transfer of value =B1 to the value of the type of technique hide empty lines with number No displaying only filled lines with the name and catalogue number.Cover the columns D, G, H, I, L, M. The principle of work: The list of requests indicates the product, catalogue number, number.The 1-10 lists indicate the prices of the suppliers in their currency with the delivery of the specified goods from the request list.In the processing list, the prices of suppliers are compared and the lowest price is selected by goods position.Show the result amount of the project.We pay the work on the fact of the performance of the work or parts by direct calculation.

Proposals 5 Discussions 3