Project translated automatically. Log in or register, to view the original It is necessary to write a macro in Excel that will form from the csv file the table in the form we need.The image of what we want to get on the output indicated in the file "Upload 1.xlsx"Eastern file csvAlgorithm1) On the column E is the name of the Customer that has not been before.2) All lines with the same name of the Customer are searched3) The total volume of the lines is counted and recorded in the column L (Upload 1.xlsx)4) The values are summarized by the column N and recorded in the column M (Upload 1.xlsx)5) The selection is made by the column J, we need to leave one of the values used by the FIO.that is.If the same FIO has been used 5 times, we leave only 1 record.Another FIO within the same Customer 3 times found, we leave another 1 record, etc. If different FIOs are found, then on the first found value we take the columns K and L (address e.g.mail and telephone number).In the example I showed it.FIO is broken over the columns.Now it is written by a single cell, the format is everywhere the same - FIO.6) The rest of the Customer data, on the first found line, is filled according to the columns in (Upgrade 1.xlsx - The column headline indicates the corresponding column in the csv file)In the end, in our "Upgrade 1.xlsx" table should be a list of Customers - one customer once with filled fields, all FIO options and the corresponding FIO contact data (telephone and email) It will also be necessary to explain how to apply this macro to different files :)

Proposals 3

Please select

Ivan Moroz

99 0

Projects 81
Rating -
Rating 744

Budget: 1000 RUB Deadline: 3 days

Hello to you!
There is an attempt to write such macros.
You can see in the reviews.
I will write and explain how to use the file.
Go to turn.

Genrihs Olehno

2 0

Projects -
Rating -
Rating 38

Budget: 1000 RUB Deadline: 1 day

Good day ! I am ready to write a macro. The task is more or less understandable.

Nikolay Simon

Winning proposal

6 0

Projects 6
Rating -
Rating 276

Budget: 1000 RUB Deadline: 1 day

Hello to you!
Ready to accomplish the task.
Makros with the explanations will be available today.
Other information on request. In freelance for more than 7 years.
– –
by: nick_chizhi
Email: [email protected]
Posts by: @NickSimon

Ivan Petrov
Slovenia

Projects 63
Rating 5.0
Rating 5 677

Writing the macro in Excel

Client's review of cooperation with Nikolay Simon

Writing the macro in Excel

5.0

Ivan Petrov

Freelancer's review of cooperation with Ivan Petrov

Writing the macro in Excel

5.0

Nikolay Simon

Ivan Moroz

Genrihs Olehno

Nikolay Simon

Proposals are currently absent

Current freelance projects in the category Desktop Apps

Linux mentor

Microsoft Power Platform/Power App