It is necessary to write a formula for Excel
I have a cell with data that looks like this: 70/60 [#SK10-5C;K30-10C;K100-20C]
[#SK10-5C;K30-10C;K100-20C] - this is the code for our application, the beginning is always the same
It is necessary to select certain data from this cell depending on the set conditions (we have three)
1. Data after #SK, namely 10; 5; C
2. The last data, in our case this is 100; 20; C
3. This is the penultimate data, in our case this is 30; 10; C
Depending on the data in the cells, if there are, for example, 2 blocks of data, then in the third case the first block is taken ([#SK6-1.8B;K30-3.7B])
If there is only one block of data, it is used everywhere. ([#SK32-20C])
The cell may not have this block, or the cell may be empty
I am also sending a file for your reference on how the cells are filled
Applications 1
Client's review of cooperation with Viktor Biruk
It is necessary to write a formula for ExcelThe work was done quickly and at a high level. Communication is pleasant and clear. I highly recommend working with this freelancer!
Freelancer's review of cooperation with Mikola Pozhoga
It is necessary to write a formula for ExcelWe got a little confused in the technical specifications, but overall everything went at a higher level.
-
3668 107 0 I will write a formula that will analyze each cell, and depending on the result, process it and insert the processed data into the adjacent cells.
Contact me!
-
204 2 0 Good afternoon, Nikolai!
What version of Excel do you have?
Just to understand what set of functions will be available.
The task for Google Sheets is simple.
Sincerely, Sergey Kuzenny
-
1574 37 0 Hello.
I have experience writing formulas and macros for Excel.
I am ready to start working.
-
5852 345 0 I can analyze the expression in the cell to obtain the necessary information.
-
2215 35 0 Good day, I can help solve the task, everything is clear. Feel free to reach out.
-
2937 73 4 2 Good day! I have a lot of experience working with ET, so I will complete the task you set quickly, and most importantly - with quality!!! Feel free to reach out!!!
-
408 Hello! Do you have a specific format for outputting this data from the cell that you would like to see? I will be able to determine a more accurate time and budget in personal correspondence.
1. I will start by analyzing your file and the specifics of how the cells are filled to understand how they are composed and what differences may exist.
2. Then I will develop a script that will extract the data you need from the cell depending on your conditions. I will take into account all the nuances you described (the number of data blocks, the absence of a data block, an empty cell).
3. In the final stage, I will test the script on different variations of cell filling to check its correct operation.
Thank you for considering my proposal. I look forward to the opportunity to work with you!
-
Mikola Pozhoga Бойко Склад
По выводу данных я хочу получить три ячейки в которых будут прописаны эти данные.

-
Current freelance projects in the category Data Processing
Conduct 7–10 interviews with owners of mobile service businesses (B2B customer research)Task description:I am looking for a specialist in market research / B2B interviews. It is necessary to communicate (phone or video call, 15–25 minutes) with 7–10 owners of small mobile service businesses in Ukraine — cleaning, plumbing, electrical work, equipment… Information Gathering, Data Processing ∙ 1 day back ∙ 2 proposals |
Building financial models (P&L + Cash Flow)We are looking for a qualified specialist who can help organize our business finances. We need to develop and implement two key reporting forms: P&L (profit and loss statement) and Cash Flow (cash flow statement). Please provide your work experience, what you have worked on,… Accounting Services, Data Processing ∙ 6 days 21 hours back ∙ 17 proposals |
Assistant to the manager for project work in the field of science and scientific publicationsLooking for a responsible assistant to work with personal social networks, a contact database, and current projects in the field of science and scientific publications. At the first stage, the collaboration is planned for one month. The main task is to assist with basic… Information Gathering, Data Processing ∙ 7 days 13 hours back ∙ 12 proposals |
Contacts of the Northern European countries
28 USD
Hello everyone I need to find contacts of companies (Cleaning Company) that are engaged in cleaning in one of the niche industries - shipping. These companies deal with cleaning ships of various purposes, - cargo ships (only cleaning of ships) and the service is called - cargo… Data Processing, Information Gathering ∙ 9 days 12 hours back ∙ 22 proposals |
Search for contacts_Southern Europe (Greece, Italy, Spain, and France (south and north of the country))
22 USD
Hello everyone I need to find contacts of companies (Cleaning Company) that are engaged in cleaning in one of the niche industries - shipping. These companies deal with cleaning ships of various purposes, - cargo ships (only cleaning of ships) and the service is called - cargo… Data Processing, Information Gathering ∙ 9 days 13 hours back ∙ 20 proposals |