Screenshots for Google Spreadsheets 2
You need to write a script or macro or function in the Google spreadsheets, which will do the following:
1) Take the domains from a column of the search list
2) Search them on all other leaves in column A
3) If coincidence was found - enter the name of the list on which it was found, in column B of the Search list
I am adding an example:
HTTPS://docs.google.com/spreadsheets/d/1VA3dHpWVL6sTaycpHvCQ9AQApdVr89d5JFV9brQYh3c/edit
The number of lists and domains in the list will change (enlarge or decrease).
Client's review of cooperation with Anton T.
Screenshots for Google Spreadsheets 2The task is done quickly and quality! I recommend cooperation!
Freelancer's review of cooperation with Oleksandr L.
Screenshots for Google Spreadsheets 2The customer answered the clarificing questions before the start of the work, checked the work of the script in the agreed time.
-
5852 345 0 I can write a script in Google spreadsheets to search for the arbitrary number of lists and names in the lists.
We need to clarify the nuances.
-
4927 491 0 2 Good night !
I can do tomorrow.
I put a button in the top menu to start the script.
According to the required functionality, everything is clear.
Go to turn.
Current freelance projects in the category Desktop Apps
Need an Airtable architect to build a relational schema and a new clean Airtable base.Need help rethinking and building a clean relational schema for an internal operational system on Airtable. The current database is already in use by the team, but it has grown organically: the structure is partially flat, some tables/views are actively used, while others are… Databases & SQL, Desktop Apps ∙ 4 days 17 hours back ∙ 10 proposals |
Creation of software for generating cutting files for wooden puzzlesWe are looking for a developer to create software that automates the process of building cutting files for wooden jigsaw puzzles. Current Process Currently, each file is created manually by a designer in Adobe Illustrator. The file contains: the outer contour of the puzzle in… Desktop Apps ∙ 4 days 21 hours back ∙ 14 proposals |
Small edit on the website
16 USD
Need to update the offer agreement in the footer to a new one, the company has changed its regulations Task will take 20 minutes Web Programming, Desktop Apps ∙ 5 days 23 hours back ∙ 112 proposals |
Account reconciliation tool with the bank, cards, and accountantTechnical Assignment: Tool for Reconciling Accounts with Bank, Cards, and AccountantGeneral Goal A local tool (script/small application in Python) is needed, which is manually run once every 1-2 months on my computer and performs reconciliation between: Invoices I issued to… Python, Desktop Apps ∙ 8 days 6 hours back ∙ 44 proposals |
Add pauses of 10-30 seconds between sending emails.Hello! I am looking for an experienced 1C / BAS (BAF) programmer to promptly resolve a technical issue with email distribution.Problem essence: We use the accounting program BAF (Business Automation Framework), version 2.0. Once a month, there is a need to send about 300 emails… Web Programming, Desktop Apps ∙ 13 days 22 hours back ∙ 11 proposals |