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 :)

Applications2

XLSX

Надстройка 1.xlsx

11KB

CSV

образец.csv

3KB

Proposals 3

Please select

Ivan Moroz

99 0

Projects 81
Rating -
Rating 704

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

Current freelance projects in the category Desktop Apps

Need to transfer the site from Webflow to WordPress.

Web Programming 63 proposals 3 August

Not specified
Refinement of the CRM in 1C: displaying the client's bonus balance

Testing & QA 12 proposals 29 July

Not specified
Setting up multiple Viber accounts on one remote desktop

13 proposals 28 July

Not specified
Light application

PHP 66 proposals 28 July

172 USD
App : Digital Marketplace for Skilled Trades in Morocco

Web Programming 66 proposals 22 July

500 USD

Ivan Petrov
Slovenia

Projects 63
Rating 5.0
Rating 5 697

Ivan Petrov

Nikolay Simon

Ivan Moroz

Genrihs Olehno

Nikolay Simon

Proposals are currently absent

Current freelance projects in the category Desktop Apps

Need to transfer the site from Webflow to WordPress.

Refinement of the CRM in 1C: displaying the client's bonus balance

Setting up multiple Viber accounts on one remote desktop

Light application

App : Digital Marketplace for Skilled Trades in Morocco