Screenshot for Google spreadsheets, selection and composition of values
7 USD https://docs.google.com/spreadsheets/d/1pIznSLULlr7nLJq0Ux5s1FKxIkVfw9lSeFe5O-M5Kc/edit?usp=sharing
There are a few lists, namely:
BT x Kubay Design - the main working sheet
BMW - Mercedes - Audi - lists indicating the year of production for each model accordingly
The task is to write a script that will perform the following action:
1 .In the BT x Kubay Design list, the E2 cells will take the first value "W163"
2ndGoing on the Mercedes sheet (the lists are now distributed separately for convenience, then all the values of the model - the year can be covered on one list) will find the value of "W163", in the 52th line, will take the value of the year to which it corresponds "1998-2005"
ThreeIn the BT x Kubay Design list, the F2 cell will create a type record: "1998-2005 Mercedes-Benz W163," where:
"1998-2005" - the value found in the brand list by car model
"Mercedes-Benz" - value from the D2 cell of the BT x Kubay Design
"W163" - and the model accordingly
After this cycle should be repeated for all models in the E2 cell.
In order to get a type record in F2:
1998-2005 Mercedes-Benz W163
2006–2011 Mercedes-Benz W164
2011-2019 Mercedes-Benz W166
2019–2022 Mercedes-Benz W167
...
It is also necessary to verify the duplicates of models in the E column, that is, so that the records are not duplicated later.
Client's review of cooperation with freelancer
Screenshot for Google spreadsheets, selection and composition of valuesVery pleased with the work with the staff! The project was realised in 30 minutes, on my request, I entered a few more directions. I recommend cooperation!
Freelancer's review of cooperation with Viktor Kurgak
Screenshot for Google spreadsheets, selection and composition of valuesEverything is great.
I will be glad for further cooperation.
-
1 day7 USD
1115 109 0 1 day7 USD
Good day Victor!
The task is clear, I can do it now.
I write a script for a Google table or a macro for Excel.
You can then use it to process similar files.
-
1 day9 USD
336 4 1 1 day9 USD
Good day . There is experience in working with Google and Google script. I understand how to do. About 2 hours.
-
1 day9 USD
270 8 0 1 day9 USD
Welcome to! As if nothing is difficult, there is only one desire to name the tags as the brand is recorded in the "D" column (so it will be better to search) . Work for a maximum of 2 hours with testing. I can do
-
1 day23 USD
3676 107 0 1 day23 USD
Does the macro only work with the cell E2?
Or with all the cells in the column?
-
1 day11 USD
397 56 3 1 1 day11 USD
Good night ! So in the east, based on the description you don’t need a script at all here, a few formulas are enough. turn to
-
Так на каком языке это нужно?
-
Viktor Kurgak Ai-Ti
Язык програмирования мне не важен, мне нужен результат
-
Вам нужно обработать только этот документ (как угодно получить результат и забыть) или сама автоматизация тоже нужна (на будущее для других подобных документов)?
-
Viktor Kurgak Ai-Ti
Желательно иметь универсальный скрипт, для дальнейшей такой же обработки
-
скрипт будет долго работать за счет необходимости перебора всех строк таблицы, мне кажется можно без него обойтись
-
Viktor Kurgak Ai-Ti
Вам виднее, это разовая операция, можно и подождать. Если можно обойтись то почему бы и нет
-
Current freelance projects in the category Javascript and Typescript
Website design updateIt is necessary to update the design of the existing website using HTML, CSS, JS: refresh the appearance, make it modern and responsive for mobile devices. Smooth animations and interactive elements need to be added. HTML & CSS, Javascript and Typescript ∙ 11 hours 58 minutes back ∙ 67 proposals |
Consultation and audit of the current project on Odoo 19 Community Edition
We are looking for an Odoo Developer — a solo developer with experience in Odoo 19 Community Edition, including using Claude Code. We need a specialist who has successfully implemented projects in Odoo and practical experience in development using Claude Code. Important: we only… C & C++, Javascript and Typescript ∙ 17 hours 37 minutes back ∙ 5 proposals |
Online clothing storeNeed a developer for an online clothing store Looking for an experienced developer to create a full-fledged online clothing store with a drop model of sales. What needs to be done: 6 pages: home, product, cart, checkout, account, admin panel Login via Google account Cart and… HTML & CSS, Javascript and Typescript ∙ 2 days 14 hours back ∙ 98 proposals |
Full-stack development — Amazon PPC Dashboard (Stage 1)Need a full-stack developer with experience working with Amazon API to implement Stage 1 of the internal PPC dashboard. The project is real, the data is live, everything is ready to start. Frontend prototype (5 pages, React + TypeScript): WHAT IS ALREADY READY — Frontend… Javascript and Typescript, Web Programming ∙ 5 days 1 hour back ∙ 32 proposals |
Development of a photo book and photo frame constructor websiteProject Goal A modern website needs to be developed for ordering photo books, photo frames, and other personalized photo products. The main task of the project is to provide the client with the ability to independently create a ready-made layout of the product directly on the… Javascript and Typescript, Web Programming ∙ 6 days 17 hours back ∙ 99 proposals |
Poltava