Create a program (or set macros) to work with a Excel table
15 USDThere are a few thousand lines in the table.
Each line is one payment from one client.
The lines are sorted by the alphabet, and repeated values are assigned. To see payers who have paid more than 1 times (see example).
Needed to:
1) transfer all lines with repetitive values into a separate poster.
2) remove from the table all lines with repeated values.
and th. From one "mixed" table should appear 2 - about customers once, and about customers repeated).
3) it should be counted as much as the total number of repeated customers (how many lines with repeated values).
Есть таблица (выписка из банк-клиента).
В таблице несколько тысяч строк.
Каждая строка - один платеж от одного клиента.
Строки отсортированы по алфавиту, и выделены повторяющиеся значения. Для того, чтобы видеть плательщиков, оплативших более 1-го раза (см.пример).
Нужно:
1) перенести все строки с повторяющимися значениями в отдельную вкладку.
2) удалить из таблицы все строки с повторяющимися значениями.
(т.е. из одной "смешанной" таблицы должно появится 2 - про клиентов-одноразовых, и про клиентов повторных).
3) должно посчитаться, сколько всего повторных клиентов (сколько строк с повторяющимися значениями).
Applications 1
Client's feedback on cooperation with freelancer
Create a program (or set macros) to work with a Excel tableEverything worked greatly!
25 signs
Profile deleted | Safe
Freelancer's feedback on cooperation with client
Create a program (or set macros) to work with a Excel tableI really liked working with Alexey - he detailed the TZ, communicated kindly, quickly gave all the necessary directions on the project.
Profile deleted | Safe
Current freelance projects in the category Databases
Data table formatting and RFM analysis1. The CRM table of all customer orders has been exported. It needs to be formatted in such a way that it becomes convenient for reading and working. The following columns should be included: customer (full name), phone number, total number of orders, date of the last order,… Databases, Data processing ∙ 2 proposals |
Set up the transmission of the array rro_info in payments from the WordPress website
25 USD
Implement the transfer of the rro_info array via API in order to fiscalize payments using the LiqPay payment aggregator. A mandatory condition for fiscalization is the presence of data on the goods for which the payment is made. To transfer data on goods in the Liqpay request… Databases, Web programming ∙ 1 proposal |
Online store improvement!!! Please, experience with OpenCart 3 of 3 years !!! 1. **Performance optimization:** - Identification and elimination of performance bottlenecks in the store, such as slow database queries, inefficient algorithms, etc. 2. **Development and implementation of new… Databases, Web programming ∙ 1 proposal |
Extract data from CSV and export to Google Sheet
127 USD
Good day! It is necessary to extract data from about 10 csv files (each containing no more than 200 rows and 10 columns) of a specific format, process them, and export them to a google sheet according to a template. I will provide the original csv files to the final developer… Python, Databases ∙ 11 proposals |
Reduce the disk space occupied by the websiteAnalyze how to reduce the weight occupied by the site on the hosting and reduce this weight. The current weight is 32GB, although the site is still in the launch stage. Website: megasockcs.com.ua Ideally, it would be to reduce the weight by at least half if possible. If not,… Databases, Web programming ∙ 11 proposals |