The formula for Google tables
11 USD List 1 in which you need the formula to fill the data, Socr. cities that should be reduced
Now there is a formula that encourages reductions, but only when in List1 in column B (Country reduction) one country is set. If there are several countries, the formula is no longer working.
The task is to make the formula work correctly and make the cuts according to the list (Soc. cities of those) regardless of one or more countries.
In the list of Socr. There will be a lot of cities (there are already 40k and will expand).
If in List1 there is nothing in the cell, it will be empty.
It is also worth noting that in different countries there are cities with the same name. Therefore, when writing the formula, it is important to retreat from column B in which country to look for a reduction.
https://docs.google.com/spreadsheets/d/10FE3fSXls8bHgNcl5xolzDzEz8IDLXytoxg_cFu9ow8/edit?usp=sharing
Please specify your price and time. Thank you !
Client's review of cooperation with Anton T.
The formula for Google tablesThe second very useful and quality script from Anton. Complicated projects are resolved with Anton easily and easily! Thank you very much for the work! I recommend cooperation!!The !
Freelancer's review of cooperation with Evgeniy Zhak
The formula for Google tablesThe customer quickly checked and successfully closed the project.
-
Winning proposal1 day11 USD
5902 345 0 Winning proposal1 day11 USD
You can try to create a formula from standard or make your own using scripts. I want to clarify the algorithm.
-
1 day11 USD
543 19 2 1 day11 USD
Good day, I can propose a solution without a formula using a script. I do it quickly and everything will work properly.
Current freelance projects in the category Javascript and Typescript
Development of the AM Mobility platform (car service, parking, insurance, car rental)
5770 USD
We are looking for a team or an experienced Full Stack developer to create the MVP of the AM Mobility platform. AM Mobility is a unified digital ecosystem for motorists, combining in one application and web platform: parking; car service; tire fitting; car wash; car rental;… Javascript and Typescript, Web Programming ∙ 4 days 3 hours back ∙ 110 proposals |
Gsap animations
22 USD
Good day. Corrections need to be made in the current project. A specialist is needed who works well with gsap/lenis. Animation of cards needs to be done. Detailed specifications here:… Javascript and Typescript, Web Programming ∙ 4 days 9 hours back ∙ 21 proposals |
Commercial on-premise video communication platform "ViM"It is required to develop an on-premise video conferencing system with a basic calculation for 100 simultaneous connections (10 isolated rooms of 10 people each). The platform should have a built-in architecture for future horizontal scaling up to 1000 users by adding new media… Javascript and Typescript, Web Programming ∙ 5 days 4 hours back ∙ 32 proposals |
I am looking for a mentor with Claude Code to launch a web project from scratch.Brief about the task: I am a beginner with no programming experience. I have a ready specification for website development (42 pages, Next.js, PostgreSQL). I want to implement it myself using Claude Code - I need a specialist who will set up the environment and teach me how to… Javascript and Typescript, Tuition ∙ 6 days 8 hours back ∙ 18 proposals |
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 ∙ 7 days 2 hours back ∙ 95 proposals |
Kyiv