Switch to English version?

Yes

Переключитись на українську версію?

Так

Переключиться на русскую версию?

Да

Przełączyć się na polską wersję?

Tak

Login
Registration
- Welcome to Freelancehunt
  
  Work risk-free, saving time and money
  
  Login Registration

Post your project for free and start receiving proposals from freelancers within minutes after publication!

10 USD

Writing the macro in Excel

10 USD

Desktop Apps

6 out of 6

project complete

publication
open for proposals
terms confirmation
reservation
work underway
project complete

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 🙂

Applications 2

Application viewing is only available registered users.

Client's review of cooperation with Nikolay Simon

Quality

Professionalism

Cost

Contactability

Deadlines

All super, Nikolai a great specialist.

Ivan Petrov | Safe

Freelancer's review of cooperation with Ivan Petrov

Payment

Task setting

Clarity of requirements

Contactability

They worked greatly.
All the nuances have been drawn up during the development.
Payment is timely.
I recommend cooperation.

Nikolay Simon | Safe

Proposals 3

by default date online rating cost completion time

10 USD

Ivan Moroz

10 USD

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.

Show original

Translate

13 March 2018, 9:43

10 USD

Genrihs Olehno

10 USD

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

Show original

Translate

13 March 2018, 9:33

Winning proposal10 USD

Nikolay Simon

Winning proposal10 USD

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

Show original

Translate

13 March 2018, 9:28

Current freelance projects in the category Desktop Apps

Modification in the emulator's operation

45 USD

Hello. I downloaded the Gaminator CF Final slot machine emulator from the Internet. I really liked it, but there are some issues. There is an admin panel, but it opens freely and cannot be closed at all. It only closes along with the application. Also, the data does not save…

Desktop Apps ∙ ∙ 10 proposals

45 USD

Development of custom software (Android application + CMS) for SUNMI K2 self-service kiosks (Fast food)

22 USD

We are looking for an experienced team or a Middle/Senior Android developer (possibly with Full-stack skills) to create proprietary software for self-service kiosks for a fast food retail chain. Currently, our terminals operate on a ready-made cloud integrator, but we are…

Content Management Systems, Desktop Apps ∙ ∙ 23 proposals

22 USD

Ivan Petrov

Slovenia 63