The formula of Exel
4 USD TZ
The Exel document has two pages.
On page 2 there is a table with two columns.
In the first column the data in the second list of values(block1, block2, block3, block4) or empty
If it is empty, we do nothing.
If block1 is selected opposite the value, then you need to put that value on a sheet1 to a specific place(in block1)
the same sl is chosen block2 then the value to the left of it should be moved to the sheet1 in the place in the block2
It will be clearer if you look at the table.
Applications 1
Client's review of cooperation with Nick F.
The formula of ExelWork is pleased! I performed quickly and well.
Freelancer's review of cooperation with Valery Knipalo
The formula of ExelClean TZ, good contact, fast payment.
I recommend it!
-
1 day4 USD
746 29 1 1 day4 USD
Hello to you. I write these formulas. I understand Excel very well.
-
1 day7 USD
1134 38 0 1 day7 USD
Hi, I can solve your task in several ways, all will depend on your version of Excel
-
1 day4 USD
412 7 0 1 day4 USD
Good day . The task is understandable. Ready to do, something like that has not been done so long ago. It is a formula, not a macro. Please call me, I will be happy to help.
-
1 day4 USD
567 28 2 1 day4 USD
How to carry? All in one cell through the back? in the cells down or left? I write a macro. Write and discuss.
-
1 day4 USD
366 25 1 1 day4 USD
Ready to write a VBA script. It will work by the button or by calling the script.
-
Добрый день,
Если во втором столбце второго листа значение "блок 1" встречается несколько раз- что выводим на лист 1? Сумму значений с листа 2, список их через запятую или ещё что-то?
-
Current freelance projects in the category Data Parsing
Consultation on parsing Instagram account subscribersHello. It is necessary to conduct a preliminary assessment of the feasibility of the following task. I have a list of Instagram accounts. The goal is to obtain contact information (primarily email addresses) of users who follow these accounts. Previously, I encountered companies… Data Parsing ∙ 3 days 8 hours back ∙ 12 proposals |
A specialist is needed to find contacts of decision-makers in Ukraine.It is necessary to gather a database (or ready database) of contacts of decision-makers (DMs) in companies in Ukraine. Information Gathering, Data Parsing ∙ 3 days 12 hours back ∙ 17 proposals |
Need to scrape data from LinkedIn
We need to scrape data from LinkedIn based on our list. For each entry, we need to find and collect available data if it exists on the LinkedIn profile, including the profile picture on the LinkedIn social network, email address, links to social media, company website, and… Data Parsing ∙ 3 days 18 hours back ∙ 27 proposals |
Parsing and classification of data
We are looking for a developer to implement a system for collecting and structuring data from open sources. We have a database of small business owners in the USA, which contains the person's name, company name, address, and state. It is necessary to build a process for… Web Programming, Data Parsing ∙ 3 days 19 hours back ∙ 41 proposals |
Svitlahata
17 USD
It is necessary to import 1819 products from the XML/YML feed of Prom.ua to OpenCart 3. A ready XML file is available, which contains product names, descriptions, prices, photos, specifications, manufacturers, and categories. Requirements: import all products to OpenCart… Content Management Systems, Data Parsing ∙ 4 days 22 hours back ∙ 34 proposals |
Kyiv