Google sheets array formula filtercông việc

I am in need of a dynamic individual who is proficient with React and Yup to develop an array list for the purpose of validating form submission data. The specific fields that need to be validated are not defined as of yet, so I would require flexibility in incorporating changes as needed. Past experience and extensive knowledge of using Yup with React is essential for this task, as is a detail-orientated focus to ensure accurate and efficient input validation.

...of Sale (POS) system, and warehouse stock counts. Key responsibilities: - Regularly updating our inventory data with utmost accuracy - Ensuring all channels of data (supplier invoices, POS system, stock counts) are accurately reflected in our inventory records - Generating purchase orders based on the updated stock levels Your skills and experience should include: - Proficiency in Excel/ Google Sheets - Experience in inventory management/data entry - Attention to detail and accuracy - Ability to work independently and meet daily deadlines - Familiarity with purchase order generation is a plus. A successful candidate will not only update the inventory data accurately and promptly but will also be able to adapt to any changes in stock levels in real-time, ensuring our p...

I'm in need of a fitness expert who can develop a comprehensive personal training program sheet for my clients. The ideal candidate would have a strong understanding of exercise physiology and program design, as well as extensive experience in personal training. The program should cater for three main fitness goals: - Weight loss - Muscle building - Endurance training It should also cater to two levels of fitness experience: - Beginners - Intermediate The training frequency may vary, though it typically falls between 3-5 days a week. I need the program to be versatile and adjustable according to the individual's schedule. Include - Nutrition - Graph for progress (weight, fat percentage, habit tracking, calories/steps calculator) whether fitness watch can be attached) Skil...

I am seeking an expert in Google Cloud's Pub/Sub service. My Python application needs to publish and subscribe to text data messages. Knowledge in message encoding and decoding, as well as Pub/Sub client libraries, is crucial. Therefore, a strong background in Python and Google Cloud Platform is required. Take a look a example image attached. Key responsibilities include: - Assisting with publishing text data messages - Helping with subscribing to these messages Please have proven experience in Google Cloud's Pub/Sub and Python programming for processing text data.

This project aims to build an informative and precise contact list for our business use. We will provide you with a list of 1000 records, and your job will be to Google each one and fill the respective information - Website, Address, City, State, Zip, Phone - into a shared Google Spreadsheet. The focus of this data collection will be on the specific records we supply. Ideal skills and experience for the job: - Strong web research skills - Prior experience in data entry - Attention to detail and accuracy - Proficiency in Google Sheets - Ability to meet deadlines.

open a pop-up that I need to be able to automatically customize in a liquid template in shopify. Be careful! this pop-up must open on product sheets when you click on add to cart.

...myriad of tasks which include, but aren’t limited to; • Advanced character leveling • Detailed item farming • Skill automation Additional features essential for these bots to possess are: • Auto potion consumption: The bot should be able to intelligently consume potions whenever required • Mob detection and avoidance: Bots must have the ability to detect and evade mobs automatically • Chat filter: It should be able to interact with other users by filtering out specific keywords or phrases There is versatility in the choice of code we are willing to accommodate for this initiative. Whether Python, Java, or C#, the primary focus should be on efficiency and effectiveness. Prior experience with bot creation for games and an understanding o...

My Portfolio website is not displaying Google AdSense ads, despite having added the code. I don't have any ad blockers enabled in my browser. I need a skilled professional to troubleshoot and resolve this issue as soon as possible. The ideal candidate should have: - Expertise in website monetization and Google AdSense implementation - Experience with Portfolio websites - Strong debugging and problem-solving skills - Ability to communicate clearly and provide updates on progress

Need person who make my website adsense friendly and get adsense approval paymant after work

i am looking out for SMTP and Technology expert who can help build an email verification platform like “MillionVerifier '’ and “Neverbounce” "listclean". 1. **Validate Email Addresses:** The platform should be able to cross check every submitted email address and validate them to confirm legitimacy. 2. **Spam Check:** There must be a provision to check and detect spam emails and effectively filter them out. 3. **Remove Invalid Emails:** The system should have the ability to remove invalid email addresses from any uploaded list or one-by-one input. 4. Hard Bounce. 6. Invalid Syntax 7. Toxic Domain 8. Abuse Email 9: API 10: Including All features site Accuracy is extremely vital to this project and the system is expected to give a high...

I have an Android app that I want to submit to the Google Play store. The app does not include any in-app purchases. This App is designed and used by 1 company only (not for all users, users can not register), that company will create and give account for their employees. Data in app is stored in company’s server. Now when we upload to Google play, it has been rejected as image below. We submitted many times safety data form with variety data, but google still reject our app. We don’t know where problem is. Our safety data from or our app, our code. The images below are API we use in our code, and feedback from Google. Please help us to submit this app to Google Play store.

...Digital agency specialising in developing Static Websites and E-commerce websites for our clients across PAN India. We are looking for a freelancer who is proficient in marketing and generates us 100 leads for our “Static Website product or Ecommerce Website product”. Any lead for other than “Static Website or E-commerce Website” will be considered invalid. All the leads will be recorded in Google Sheets. Let’s discuss if you are interested in working based on the requirements. The average Selling price of the product is Rs. 7000.00 + tax. The project needs to be strictly completed within 2 months or the project will be considered as incomplete. Payment will be released only on successful completion of the task. I am looking for an ine...

Expert google ads person need. Expert knowledge in google ads. Manage campaign Outstanding communication.

Przygotowanie oraz optymalizacja kampanii - Google ADS / Facebook ADS dla sklepu internetowego https://sklep.pat15.net. Katalogi produktów są utworzone i przesłane do Google Merchant Center oraz Katalogu Facebook. Kampania skierowana na konwersję - sprzedaż zakończona sukcesem. Można wykorzystać remarketing i kupony zniżkowe na porzucone koszyki.

I am in need of a proficient Wordpress specialist to fine-tune the intricacies of my website's homepage. Here's what requires attention: Tasks: 1 Add New Widget: The centerpiece of this project involves the addition of a specific new widget - a plugin accommodating Google comments. Your skill at seamlessly integrating this into my sidebar is crucial. 2 Modify existing Widget: Remove the 4 picturebox and add simply Picture i dont want agressive hiring no whatsapp no email no calls ! just use freelancer.com for offer your Knowledge Site URL is

...information required includes details on the CEO, senior management, and email addresses. The data should be compiled into a spreadsheet, such as Excel or Google Sheets, with separate columns for each piece of information. Key Responsibilities: - Researching and collecting information on the CEO, senior management, and email addresses of around 80 councils. - Ensuring the accuracy and relevancy of the data collected. - Organizing the data neatly into a spreadsheet, in a format suitable for subsequent upload to a CRM tool like Pipedrive. Ideal Skills and Experience: - Experience in data research and entry. - Proficiency in using Excel or Google Sheets. - Familiarity with CRM tools, particularly Pipedrive, is a plus. - Attention to detail and the ability to m...

As a client seeking to create a detailed and useful content on business report writing, I am in need of a diligent freelancer who can create business report writing...educates readers on different elements of business reports, potentially covering topics such as report structure, data analysis, and presentation techniques. - Showcase your prowess in report writing, demonstrating a high level of knowledge and competence. Ideal Skills and Experience: - A proficient understanding of business report writing. - A versatile writing style that can speak to a wide array of readers. - Exceptional researching, editing and proofreading skills. - Excellent communication skills for possible clarifications and quick revisions. Please consider your ability to meet these objectives when making...

I'm seeking a skilled Java and MySQL developer to assist me with two exercises from a training course. Here's a more detailed explanation of the job: - The exercises are centered around Error Handling and Debugging, along with Array and String manipulation and Exception handling. It's crucial that you are well-versed in these areas. -Since this is a learning exercise, I would appreciate it if the code included detailed comments and explanations. Please see the document attached for full details before bidding. Please apply only if you have experience and confidence in these areas.

...DUTIES AND RESPONSIBILITIES: – Provides copyediting, proofreading, QA, and fact checking for a variety of OCER-produced digital and print communications materials, including the HMS website and magazine, news releases, daily/weekly/monthly/periodic e-newsletters, the annual Dean’s Report, letters and emails from leadership and other community members, event invitations and programs, posters, fact sheets, long- and short-form narrative pieces, magazine inserts, video and podcast scripts, social media content, speeches, marketing materials, and other collateral as assigned. – Coordinates and prioritizes the intake of copyediting and proofing requests, assigning overflow as needed. – Ensures all written materials conform to editorial style standards, using AP...

Hello Maha As discussed I am sending you a quote as I am unable to find the project.

In this crucial project, we aim to significantly improve the cybersecurity of data stored on the Google Cloud Platform (GCP), using cutting-edge artificial intelligence methods. Our main goals are as follows: - Use Machine Learning and Deep Learning to detect and mitigate any potential cyber threats before they occur. - Utilize AI to predict and intercept Unauthorized Access, Data Breaches, and Malware Attacks, thereby bolstering our defense mechanisms. The ideal candidate will be proficient in AI, specifically Machine Learning and Deep Learning, and have extensive knowledge of cybersecurity on clouds. Experience with GCP would be a valuable advantage. It's essential for the chosen freelancer to be adept at translating complex AI algorithms into practical cybersecurity soluti...

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

I am looking for someone skilled in document conversion to shift a Google Doc into a Word document. Here's what I need: 1. Google Doc to Word Conversion: You should have experience in converting Google Docs to Word. The document is currently in Google Docs format. 2. Formatting: The specific formatting was not specified by me. Therefore, you should be comfortable working with varied formats as the task may require maintaining the original format or applying a new template. 3. Approximate Word Count: The size of the document remains unspecified. Hence, you should be open to working with anything from brief to larger Google Documents. Please note that familiarity with Google Docs and Microsoft Word is a must for this job, as is an attenti...

...Registration and Login: The app must have a robust and secure system that allows users to create accounts and log in. - Search and Filter Functionality: The app must support easy searching and filtering of listings to help users find what they're looking for efficiently. - Listing Creation and Management: Users should be able to effortlessly create and manage their own listings within the app. The ideal candidate will have: - Prior experience in developing cross-platform apps. - Proficiency in creating user-friendly interfaces. - A strong background in designing and implementing secure user registration and login systems. - Experience in developing and integrating search and filter functionalities. - A track record of enabling easy listing creation and management wit...

I'm in need of a skilled Apache Superset expert who can help me connect MySQL and PostgreSQL to the platform for exploration and visualization. Key tasks include: - Creating interactive dashboards - Generating real-time reports - Building visualizations for large datasets Features & functionalities needed in the deliverables: - Filter and drill-down options - Customizable charts and graphs - Integration with external APIs Ideal candidates should have: - Extensive experience with Apache Superset - Proven track record of working with MySQL and PostgreSQL - Strong background in data exploration and visualization - Demonstrable skill in creating interactive dashboards and real-time reports - Familiarity with building visualizations for large datasets - Ability to integrate ...

I am in need of a freelancer who can convert my Google Document into a Microsoft Word format. The task is simple but important, so I am looking for someone with proficient skills in utilizing both Google Docs and Microsoft Word software. Below are the key requirements for this job: - I need the document to be converted exactly as it is. Throughout the conversion process, the original formatting must be preserved. - Freelancers with extensive experience in related tasks are preferred. In your application, include previous similar projects you've worked on. This is a straightforward task and an ideal opportunity for those aiming to build their profile with a quick and professional job completion. If you have the right skill set and experience, I am looking forward t...

I am looking for a talented graphic designer to create an elegant logo for my fashion boutique, I M Bella's. Here is what I envision: Preferred Color Palette: - Predominantly pink, with hints of purple. Logo Style: - The design should exude elegance. Special Symbol: - Preferred symbol to be incorporated into the logo is flowers, butterfly or bird. Ideal Skills: - Graphic Design - Logo Design - Experience in creating logos for the fashion industry is a big plus. Your portfolio and design concept ideas will highly be appreciated. I'm looking forward to seeing your creative proposals.

Hi Saurabh A., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I need to change my primary domain on google workspace to my secondary domain. But it won’t let me. Who know how ?

I will provide four sheets containing monthly AWS expenses, along with an output report for the last month. I need someone to update them for April. This involves updating the month, dollar amounts, percentages, and budget numbers. Ensure that the budget corresponds to April (specified in the budget tab), all percentages are accurate, and the line chart reflects the current month's expenses.

I am looking for an SEO expert to help my website rank higher on Google. Key Requirements: - Optimize the website for Google search engine - Improve the search engine ranking for my website Additional Details: - I do not have specific keywords in mind for optimization, so I would need your help with keyword research. - The primary goal of this SEO campaign is to enhance the search engine ranking of my website. Ideal skills: - Proven experience in SEO, particularly with Google - Proficiency in keyword research - Strong analytical skills to measure and improve search engine ranking - Good communication skills to explain the process and progress to me If you have a track record of delivering tangible results and can effectively communicate your strategy, I'd lo...

We operate a Google Sheet that fetches information from another spreadsheet identified in cell C1. Users mark checkboxes in Row A and click "Build Documents." When a user picks multiple checkboxes to generate documents, the Google Script halts after 300 seconds due to an overload. 1. The objective is to devise a systematic workaround to finish processing the document batch without additional manual intervention. For example, here's a replica of the spreadsheet you can use to test your code. The documents created all appear here: In the Spreadsheet App Sscript: In "Rahul's Code". 2. Add a line of code

In need of a skilled professional who can effectively handle data entry tasks online. The project revolves around entering basic data, primarily names, emails, etc., into Google Sheets. Ideal freelancer will have: * Prior experience with online data entry * Proficiency in Google Sheets * Attention to detail with entering data * Ability to enter data quickly and accurately This job does not require any complex calculations, formulas, or programming – just straightforward data entry.

I posted this job again because I didn't find suitable developer. I'm in need of a skilled professional with experience in both Google Ads and Meta Ads. I want to implement similar script on Meta Ads. And I want to use the this api instead of OpenWeatherMeta API to get weather data. Please apply if you have a rich experience in integration between Google Sheet and Meta Ads/Google Ads Script. Please provide a quote when applying.

I'm looking for a skilled professional to run a Google Ads campaign for my website. The main goal of the campaign is to boost sales on my website. - The target audience for the campaign is national, so you should have experience in creating successful ads that reach and engage a large, diverse audience. - I have a limited budget for the campaign, so you should have experience in creating cost-effective ad campaigns that deliver results. - In addition, familiarity with key metrics and analytics in Google Ads is a must. Please provide a proposal that outlines your experience and approach to this project, along with an estimate of the costs and timeline involved.

...understanding of functionality and usability. The main objective is to redesign the current calendar on my website based on the following: - Improve the layout and color scheme. - Enhance functionality and user experience. - Smooth integration with other site features. Ideally, the redesigned calendar should support more than 50 events monthly. It should also provide a convenient feature to filter events by date. Preference will be given to those with previous experience in similar projects. Expertise in Wordpress, User Interface design, and User Experience principles are crucial for this role. Your bid should include a brief plan on how you intend to execute the redesign. Suggestions for improvements are highly welcomed. Here is additional information: My website is

I'm in need of a skilled Photoshop designer to help me create a set of 6 basic mockups for various clothing items. Key Requirements: - The mockups should be designed based on a provided pattern, not a logo or text. - The clothing items to be mocked up are aprons, sheets, etc. Ideal Skills: - Proficiency in Photoshop and experience in creating clothing mockups. - Ability to work from a provided pattern and translate it into a visually appealing mockup. - Attention to detail and dedication to producing high-quality work. If you have the skills and creativity needed for this job, I'm looking forward to seeing your portfolio and discussing the project in more detail.

I am looking for an e...Ideal Skills and Experience: - Strong command over HTML, CSS, JavaScript, and Python. - Experience in working with APIs, preferably Whatsapp API. - Knowledge of Python-based frameworks like Django, Node.js is a plus. Project Objectives: - Create a web based portal that can monitor conversations from the Whatsapp API. - Implement real-time monitoring of these conversations. - Incorporate search and filter options for easier navigation of these conversations. - Enable export option to collect conversation data. - Optional: intervene on the whatsapp conversation Please ensure your proposal includes previous related work samples, if any, along with your bid. Your understanding of the project requirements and how you plan to achieve them will be crucial to your ...

...Optimizing the checkout process for a seamless user experience I won't be able to provide an exact number of products on the site as that detail was skipped, but the designer should be prepared to handle a flexible number of products. Additional features or functionalities were not specified, however, innovation is encouraged. Proposals suggesting interesting functionalities such as product search/filter options, wishlist functionality, or customer reviews/ratings will have an edge. Communication is a key component for the success of this project, therefore, a prerequisite for starting the job is to hop on a call to discuss the project details further. The ideal freelancer should be an expert in web design, with proven experience in ecommerce platforms. Highly creative,...

...interface for managing PTU characters and accessing game resources, similar to the functionality provided by D&D Beyond. Implement features for creating and customizing Pokémon characters, including homebrew Pokémon, NPC trainers, and all current Pokémon species. Develop a system for managing character sheets, allowing users to save characters, share them with others, and load characters from saved files. Along with a system for Game masters to share, view and interact with the character sheets of their players...

...Optimizing the checkout process for a seamless user experience I won't be able to provide an exact number of products on the site as that detail was skipped, but the designer should be prepared to handle a flexible number of products. Additional features or functionalities were not specified, however, innovation is encouraged. Proposals suggesting interesting functionalities such as product search/filter options, wishlist functionality, or customer reviews/ratings will have an edge. Communication is a key component for the success of this project, therefore, a prerequisite for starting the job is to hop on a call to discuss the project details further. The ideal freelancer should be an expert in web design, with proven experience in ecommerce platforms. Highly creative,...

I'm in need of an Excel expert who can help me create a sophisticated formula for data analysis. The data I'm working with is moderately complex, involving multiple variables. It's all housed in Excel spreadsheets. Ideal Skills and Experience: - Proficiency in Excel, with a focus on complex data analysis - Experience in creating advanced formulas for data manipulation - Strong understanding of data structures in Excel and how to work with multiple variables - Previous projects involving statistical analysis would be an advantage I'm looking for someone who can not only create this formula, but also explain its function and how to adjust it for future data sets. Please provide examples of similar projects you've worked on in the past. Looking fo...

...needs to be exceptionally flexible and versatile to allow for easy manipulation and scenario planning. Key Requirements: - Create a multi-level commission scheme: The model should have different commission percentages for each level of seniority. - Cumulative Threshold Calculation: Incorporate a mechanism to calculate cumulative thresholds. - Revenue Generation Calculation: Develop an accurate formula that calculates the revenue generated. - Flexibility in Threshold Percentage: Ensure that the threshold percentage can be flexed. - Cash Retained in the Business: The final model should account for cash retained in the business after commissions. Ideal Freelancer: - Proficient in Excel: The freelancer should have a deep understanding of complex Excel functions and formulas. - Fin...

I'm looking for an expert with excellent Microsoft Word skills. The primary task is to quickly create a front and back newsletter template that fits 11x16 sheets for me. This template will serve as a crucial vehicle for small businesses to advertise their products or services. Below are the key points to understand: • Your design should be impactful and visually appealing to ensure readers' engagement. • You should have a sound understanding and experience of creating templates using Microsoft Word. • I will appreciate it if this task can be done ASAP if possible. I need to have a micro size bee available to hide in a different ad each week. Skills Required: • Newsletter Design • Microsoft Word • Template Design • Advertising La...

I'm in need of an individual with an intermediate level of expertise in Google Ads and PrestaShop. The core objective of this project is to generate leads and sales through a Google Ads campaign, specifically tailored for a PrestaShop platform. In addition, the setup and implementation of Google Tag Manager, with an emphasis on conversion events tracking, is required. Ideal candidates should have a strong understanding of conversion events tracking in Google Analytics.

I need an experienced certified Google Ads professional but I don't have time to manage all my accounts. I'm looking for an individual or team who can help take on some of my accounts. You must be strategic, and analytical, capable of identifying growth opportunities and maximizing ROI. You must be able to achieve high quality and high optimization scores. You must be an expert in campaign setup, conversion tracking, negative keyword management, etc. You must have someone on your team who speaks Fluent English to create weekly loom video updates for each account. (they DO NOT need to be on video, just voice looms doing walk-through of ad account) Skills and Experience Required: - Expertise in multiple types of Google Ads (Search, Display, Video) - Ability to de...

...share our app to a friend and a new user success to activate a new accout. - The ability to manage price type of advertiser according to our pricing strategy. For example, in the begining of publishing the app it will be free service for the first 6 months. Then it will cost the advertiser certain amount and so on.- Auction bidding - Profile Management for Sellers and Buyers - Search and Filter Options - Advanced search filters for easy navigation and discovery of listings - Searching inside the filtered results. - Messaging System - In-app messaging functionality for communication between sellers - Payment Gateway Integration - Secure payment processing for transactions - Notification System - Push notifications for new listings, messages, bids, etc. - Ad...

Tengo u a hoja de sheets muy completa para trabajar en la que quiero que se ejecuten las fórmulas a las 00, mediante macros de un bot externo, y como consecuencia no se puedan ver las formulas por parte del cliente pero si pueda el trabajar con ella.

I'm in need of a Google Ads expert, specifically someone proficient in generating calls for tech support with the help of PPC campaigns. Here's what the role involves: - Executing Google Ads PPC campaigns - Key focus on driving calls for tech support services - campaigns: PayPal, Amazon, Cash App, Zelle, Venmo, and others Ideal candidate should have: - Experience in running Google Ads PPC campaigns - Understanding of tech support industry - Ability to target ads effectively to individuals The primary service you'll be promoting is troubleshooting software issues. Hence, understanding of this niche would be beneficial. Applications are welcomed from all interested freelancers.

I'm in need of a seasoned Google Ads specialist with expertise in SEO, social media advertising, and email marketing. Your responsibility will comprise: - Planning and deploying digital ad campaigns specifically for using Google Ads tool. - Driving increased website traffic and generating valuable leads form these campaigns. - Tailored approach to reach our international customer base effectively. Key Skills: - Experienced in SEO, social media advertising, email marketing. - Proven track record with Google Ads. - Ability to understand targeted demographics, in this case, international customers. - Excellent ability in lead generation and increasing website traffic. Bidders with documented experience in international Google Ads campaign will get prefe...