Google sheets array formula ifcông việc
I have a google sheet with 400 exercises. I need to copy them all over to a notion document with a slightly different format. Here is the google sheet — https://docs.google.com/spreadsheets/d/1SCYzmyfXgZfhu4TFkBi0YQzbXjrzl4O-hVyZZ1eo1HQ/edit#gid=0 Here is the notion table (I will provide access to edit) — I need all of the videos from “Jen’s Exercise Demos” copied over with the name, the video url and the howToTips into the correct columns. All of the videos are vimeo links so should have “vimeo” selected in the videoType column Many of the tips have multiple number bullet points, I need there to be 2 lines between each bullet point, as demonstrated in the example rows. Equipment and
I'm looking to collaborate with local job providers who can work in Serbian...particularly interested in working on tasks like document creation and editing in Word, creating and editing Power Point presentations, working with Excel sheets, as well as translation and proofreading in Serbian. Key Responsibilities: - Document creation and editing in Word - Creating and editing Power Point presentations - Working with Excel sheets - Translation and proofreading in Serbian Ideal candidates should have: - Proficiency in Microsoft Office tools - Excellent command of Serbian language - Strong attention to detail - Prior experience in translation and proofreading - Ability to work collaboratively and meet deadlines If you're a local job provider who meets these cr...
I need assistance with a small-scale copy and paste data entry task. The data is less than 1,000 rows and is in a spreadsheet format. Ideal Skills and Experience: - Proficiency in spreadsheet software such as Excel or Google Sheets - Attention to detail to ensure accurate data entry - Efficiency in copy and paste tasks to complete the job promptly This is Medium Task for 1 day Max and will be Fixed Price of 800RS. We have to Refer the Raw File and Practice test for the Students and will it in the correct format in the Practice Bulk upload
I'm in need of an expert who can work on my site's SEO and Google Ads management. Key Points: - **SEO Enhancement**: My primary aim is to improve my website's search engine ranking. The current performance of my SEO is rated as 'poor', so this is a critical area of need. - **Google Ads Management**: In addition to SEO, I'd love to have a professional who can efficiently manage my Google Ads campaigns. Experience with this is a must. Ideal Candidate: - Proven track record of significantly improving SEO for websites with poor performance - Prior experience of managing Google Ads campaigns effectively - Strong analytical skills to optimize SEO and Ads for maximum visibility and engagement
I'm looking for a professional who can help me establish and manage my Google Business Reviews from scratch. The ideal candidate should have: - Experience in setting up Google Business Reviews for service-based businesses. - Ability to generate genuine positive reviews. - Post reviews for my business Please feel free to share your relevant experience and provide a brief overview of your approach to this task.
I'm looking for a skilled developer that can create a comprehensive CMS platform for handling loan data. Key Functionalities: - User Management: The CMS should have the ability to manage users, with a specific focus on admins. - Reporting and Analytics: The system should incorporate robust reporting and analytics features that...system. Rejected Applications: - The system already have a mechanism in place to handle rejected loan applications. Ideal Skills: - Experience with CMS development - Strong understanding of data management and analytics - Proficiency in user management systems - Prior experience with loan application systems would be a plus. Note: We've google sheets which save all the data as of now. We want all the data to be migrated to Admin instead ...
As a client, I require the expertise of a Python programmer who's adept at scripting. The centerpiece of the project is to write an algorithm for stereo vision and pose estimation. Notably, OpenCV will be the preferred library for this task due to its robust array of features. ArUco markers are being used as objects for calibration. Requirements: - Experience in Python scripting - Ability to write an algorithm for stereo vision and pose estimation - Proficiency with OpenCV Your relevant portfolio that illustrates your competency in the above tasks will be highly appreciated.
I’m seeking a Google Ads expert to help me resolve errors and enhance the overall input and output mechanisms of my campaign. Key Requirements: - Correcting incorrect or unexpected output. - Enhancing the input process to make it more user-friendly. - Addressing issues with incomplete information and output that is hard to understand. Your role will be not only to resolve these issues but also to optimize the campaign to help me achieve my primary goal - which is to significantly improve the performance of the ads. Key Skills and Experience: - Proficient in Google Ads, with a proven track record of successful campaigns. - Strong understanding of data analysis and interpretation. - Experience in troubleshooting and fixing errors in Google Ads. - Excellent com...
I'm seeking an experienced professional to create and manage a Google Ad campaign specifically designed to generate leads. My primary audience are professionals aged 25 to 54 years. The campaign should target professionals across the entire country. - Effective lead generation tactics - Extensive knowledge in Google Ads - Ability to target professionals (25-54 years) nationwide - Proven strategy to create nationwide interest The ideal freelancer for this project would have a strong background in delivering successful ad campaigns with a high conversion rate. These skills and experience will be crucial in reaching the campaign goals efficiently. I look forward to viewing your proposals.
I am looking for a Google Ads professional to fix my websites, google ads approval with specific Google ads errors listed that I simply do not have the time to do, but wish to have running again as they were successful until the conversion to google analytics for etc., I went through quickly and made some changes and seems it was a approvable, but there is something that was hinted is easily fixed however, someone with Google Ads knowledge would be able to quickly identify and fix whereas I would have to spend an much more time to identify it Main Goal: Increase website traffic Target Audience: it is HVAC ecommmerce heavy equipment sales which are shipped into the field, nationwide with fulfillment centers in nearly every state, so ship to the fields lo...
I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.
I urgently need a business plan and cash flow forecast for my construction business. The main aim of this plan is to eval...operational plan that outlines how the business will function on a day-to-day basis. This should cover areas such as procurement, logistics, project management, and workforce planning. - Financial Projections: I need detailed, realistic financial forecasts that will help me understand how my business will perform over time. This includes cash flow projections, profit and loss statements, and balance sheets. The ideal freelancer for this job should have: - Proven experience in creating business plans for construction or related industries. - Strong analytical skills and understanding of financial forecasting. - Ability to deliver high-quality work under a tight...
I'm experiencing difficulty with broken links and duplicate contents on my Google Search console. I have a large number of broken links we dont use amounting up to 36000. I am looking for an expert can help to clean up and remove all this links. See attached images of the issue The ideal candidate should have: - In-depth understanding of Google Search Console. - Experience in fixing broken links. - Experience in identifying and fixing duplicate content. - Excellent problem-solving skills. - Proficiency in SEO (Search Engine Optimization).
As an individual currently managing a project with numerous details and a profit loss statement, I need assistance with daily tasks for our Excel sheets. This will include: - Data entry and organization to streamline workflow - Basic arithmetic calculations for accuracy - Statistical analysis to make informed decisions - Formatting and visual presentation for clarity This role requires proficiency in Excel, a keen eye for details, and strong analytical skills. Experience in financial or project management is a plus. The job will be ongoing and requires daily attention. If your expertise aligns with these needs, please apply.
...Please only bid if you can start right now and I award straight away. I need a professional who can assist me in finding and saving 6-8 images and 1-2 data sheets for 65 items from a single website. Key Requirements: - The images and data sheets are located in specific sections on the website. Search for product name, select product name and then save images and data sheets. - The collected images and data sheets should be organized by item name and saved into directory name and complete directory containing all information sent to me Skillsets Required: - Excellent web research skills. - Proficiency in data and image saving. - Ability to organize and name files properly. - Detail-oriented to avoid any mix-up. - High level of patience for manual...
I'm in need for a reliable and seasoned customer service lead. Primary responsibilities will include: - Managing customer inquiries specific to our product using the Software Gorgias Experience in providing customer service, especially in the handling of product-related inquiries, is a must. The specific expertise level for product understanding can be considered negot...advantage. In this role, you will be the front line of support for our customers and a critical part of our company’s customer satisfaction ambitions. Ideal Profile: - Previous experience in customer service management - Exceptional communication and problem-solving skills - Ability to handle product-related inquiries effectively - Possess a customer-oriented approach. - Knows how to work with Google...
...Assistant with mid-level experience. Your main tasks will include managing schedules and appointments, handling correspondence and emails, and organizing travel arrangements. We’re on a mission to become the number one product development company in the world, and we need you to make that happen. Our two directors have recently moved to Bali and invite you to become part of their personal team. If you love planning out the perfect day, organising teams, scheduling events and retreats, negotiating with third parties, and over-delivery, you’re made for this job! The work itself will be flexible, and we will respect your boundaries, but we will ask you to be available for help on many days of the year including public holidays or weekends. As you progress in this ro...
...experience in improving search engine rankings, specifically on Google. To achieve my goal, I'll need you to: - Develop a strategy to boost the rankings of brand-specific phrases and industry-specific terms - Utilize up-to-date Google SEO guidelines and strategies to ensure our website consistently ranks high and attracts organic traffic - Monitor SEO performance and provide progress reports on a consistent basis The perfect freelancer for this project would ideally have extensive SEO experience with a particular focus on Google. Proficiency in keyword research and understanding of brand and industry-specific phrasing is also essential. Your understanding of SEO trends will be critical in keeping our website on the first pages of Google search. Let...
I am looking for an experienced interface developer to create and implement a real-time synchronization system between the Amazon SP API and Google Sheets. Key Responsibilities: - Create an integration for inventory management, using Amazon SP API and Google Sheets. The candidate must ensure up-to-the-minute data accuracy. - Develop and manage product listing and catalog management on Amazon SP API, synching this with Google Sheets in real time. Skills & Experience: - Proven experience with Amazon SP API - Expertise in Google Sheets and real-time data synchronization - Strong understanding of inventory and catalog management systems.
I am in search of a proficient virtual assistant who is adept at listing products on Wix and Shopify. Your primary task will be to assist with the listing of an array of clothing items on these platforms. Ideally, the candidate should possess: - In-depth understanding of Wix and Shopify platforms - Proficiency in product listing across multiple categories, preferably clothing - Excellent attention to detail to ensure accurate descriptions and optimal keyword use - Experience with product photography or digital photo editing is an advantage - download product images and editing to the theme and layout of our website - Come up with product names, product description that is SEO optimized - Work closely with founder to fix price and work on website Required: - A desktop, Laptop tha...
Looking for the Best Google PPC Expert! Must have 10 years experience or more! Must run You Tube Ads as part of a dynamic worlds most amazing puppy store.
Vui lòng Đăng Ký hoặc Đăng Nhập để xem thông tin.
I'm in need of a skilled developer experienced in Google Cloud Vision API and ASPRunner to implement real-time multilingual text translation feature within my current project. Requirements: - Integration of Google Cloud Vision API into my ASPRunner project - Implementing text recognition specifically for real-time translation - Ensuring support for multiple languages is available
I'm looking for a freelancer to help with a simple Excel data entry task, as well as some basic formula work. I have a spreadsheet that primarily contains numbers. Your role would be to accurately type this data into the sheet, ensuring that every entry is correct and in the right format. This task is meant for particular record-keeping purposes, so precision and attention to detail are crucial. In addition to the data typing, I need some basic Excel formulas applied. Experience with Excel and knowledge of formulas is essential to ensure the data is well-organized and easy to work with. This task is not overly complex but will require someone who is proficient with Excel's formula functions.
Requiero que mi sitio web aparezca en los primeros lugares de google cuando alguien realice una búsqueda.
I am looking for a Google Analytics expert to help me properly set up Google Analytics tags on my website. Key Requirements: - Google Analytics: I need the selected freelancer to have a deep understanding of Google Analytics, especially in the context of e-commerce. You will be responsible for checking the existing Google Analytics tags on my website and ensuring that they are properly set up to track website traffic. - Tag Manager: Proficiency in Google Tag Manager is a must. You should be able to review the current implementation and adjust as necessary to meet the goal of tracking website traffic. - Attention to Detail: You should be meticulous and detail-oriented, ensuring all tags are correctly placed and triggering as expected. Ideal sk...
I am seeking a proficient Google Sheets expert to construct a live dashboard/leaderboard that visually represents daily sales tallies completed by individual sales reps. Key specifications: - Data to be pulled from a Master Google Sheet. - Incorporation of both total sales and individual rep sales. - The dashboard should display sales data for the current day while maintaining access to historical data. - Historical sales data should be visualized through a bar graph. Skills & Experience: - Attention to detail - Time management and delivery on tight deadlines - Proficiency in Google Sheets - Experience in creating dashboards. - Familiarity with data visualization and report generation - Strong analytical skills and precision Your ability to del...
I need a professional to help me move my Google Workspace from a third party to a direct Google domain. - Current Plan: Business Starter - Key Features: Primarily relying on Email, Drive storage, and Calendar - User Accounts: Between 11 and 50 Ideal Freelancer: - Proficient in Google Workspace management - Experienced in domain migration - Familiar with preserving data integrity - Good at minimizing downtime for users I need to ensure a smooth transition without data loss. Please include your experience and approach in your bid.
I'm in need of a mobile designer proficient in creating vibrant, interactive designs for an entertainment-based project - a nightlife discovery platform. This app is aimed at simplifying and enhancing users' nightlife experiences. The user base will predominantly be Zen-z Key features include: - Event Listings: Ability to display and manage an array of upcoming events. - Venue Recommendations: Tailoring suggestions to user preferences. - User Reviews: Ensuring a transparent and interactive platform where users can share their experiences and feedback. We will be calling events as experiences which have details of both event and venue Ideal candidates should have prior experience in designing similar platforms and should be able to align their creativity with the app&r...
I'm looking for a skilled Ninja Trader developer to make adjustments to an existing indicator. The changes required include: - Adjusting the indicator's calculation formula: This involves fine-tuning the parameters and logic of the current formula. - Modifying the visual appearance of the indicator: Changing the color scheme and customizing the font or text size are some of the visual modifications needed. - Adding new features or functionality to the indicator: I'm looking to incorporate additional capabilities to the indicator to enhance its utility. The ideal candidate should have: - Demonstrable experience in Ninja Trader 8 development - A strong understanding of indicator calculation and visual customization - The ability to implement new features effect...
...metadata. I need an expert to convert this metadata into Google Earth points. Key requirements: - **Automatic Generation:** The points should be created by extracting metadata from the images, not manually added. - **Output Format:** I need the final points to be saved in KML format, for easy integration into Google Earth. - **Quality Assurance:** Accuracy is key, the points should correctly represent the image positions. They will be broken into 3 colours depending on the date they were taken, the data is in the folder name and file name. Ideal Skills: - **GPS Data Handling:** Understanding of how to extract and work with GPS metadata from images. - **Google Earth Proficiency:** Experience in creating KML files and working with Google Earth is a m...
The ideal candidate will possess a comprehensive grasp of the intricate regulations surrounding the legal rights of individuals implicated in drug-related DUI charges, coupled with expertise in specimen handling and upholding the chain of custody's integrity. To support the development of two content pieces, an array of evaluations and a significant volume of personal data will be furnished, necessitating strict adherence to medical documentation protocols. It is crucial to independently assess the evidence provided to mitigate potential biases from prior MRO reports and offer an additional expert viewpoint. Content Pieces: 1. Simplifying toxicology for a lay audience and the media. 2. Incorporating new information beyond the court-mandated disclosure for anticipated outcomes....
I need a seasoned developer to create a website primed for Google News. Your task includes setting up Google Publisher Centre, Google AdSense, Google Console, and Google Analytics. This entails: - Ensuring the website is in accordance to Google News guidelines - Integration of relevant Google services for better website functionality - Focus on global news content provision - Mechanisms to generate revenue through ads - Tools to track website traffic Skills: - Expertise in setting up Google services - Incredible attention to detail - Proficient in SEO - Experience in news websites would be an advantage Your role will be from start to finish, and your job would revolve around equipping the site to allow me to create my own articl...
Hello, I'm looking for someone to create a Google Sheets spreadsheet filled with YouTube URLs that meet the following criteria: * License: Must be Creative Commons licensed. * Visuals: - Full face visible, speaking directly to the camera; the rest of the body can be included. - Only one person in the shot and speaking throughout the entire video (no cuts to other people). * Quality: High definition (HD or better), not grainy. * Editing: Minimal editing; should be a single take (intro and fade out are acceptable). * Audio: Clear speech; background noise or music is okay if it does not overpower the speech. * Occlusions: No obstructions, such as hands or microphones, in front of the face. * Emotion: Videos displaying significant emotional expression...
I'm seeking a professional who can create a product sell sheet. This will serve to attract potential customers, provide detailed information about the product and highlight its unique selling points. This sheet will mostly target business professionals and specific industry professiona...Key details that must be included in the sell sheet are a compelling product description and relevant pricing information. Please note that mastering the balance between being informative yet persuasive is key for this project. Ideal skills for this job: - Copywriting - Graphic Design - Marketing & Sales - Industry-specific knowledge could be an asset Experience in developing impactful sell sheets will be highly appreciated. Please provide relevant examples in your bid. Looking forward t...
I'm in need of an Excel formula expert to help me with a specific task. I need a formula that will COUNT cells based on the following criteria: - I need to COUNT the number of cells in a range that are greater than -250 - The count should be done for the last 50 cells (ongoing) Your task will be to help me create a formula that dynamically counts the number of cells based on the above criteria. I need this formula to be able to adjust as new values are added to the range. The ideal Freelancer for this project should have: - Extensive experience with Excel functions and formulas - Strong understanding of dynamic range referencing in Excel - Excellent communication skills to explain the logic behind the formula in layman's terms Please includ...
Hello, I am looking for someone who can do static calculations for the building facade. Details will be given below. M profile (70 * 20 * 0.5 mm), L anchor (80 * 90 * 50 * 3 mm), box profile (30 * 20 * 2 mm) in the lower carcass of the building facade. ) will preferably be of these dimensions and 12 mm fiber cement sheets will be placed on the carcass, but according to the static calculation, the most suitable and economical solution is desired, the building will be 26 floors. It is not a complex project, only the static calculation of the profile carcass to be made for the facade cladding needs to be made, I will share the details later.
Monthly Google SEO - USA On page SEO and off page SEO
As a highly-technical individual running an N8N instance, I'm currently seeking a savvy OAuth expert to assist with the integration of Google Sheets. Key Responsibilities: - Import a limited volume of entries (less than 1000) from Google Sheets into N8N - Establish a consistent data syncing process between N8N and Google Sheets Ideal Candidates: - Have an extensive background working with Google Sheets and OAuth - Proven experience smoothly and efficiently accomplishing similar projects in the past I'm looking forward to hearing from candidates who can demonstrate their OAuth expertise and problem-solving aptitude in their application.
...costs. Member Registration: Develop a module for member registration capturing key details such as Name, address, and any other contact information. Village, group, area, district, province, sub-group affiliation (e.g., Study circle, VSLA, commodity association etc.) Demographic information (age, gender, household size, etc.) Implement functionality to adapt and import member data from Excel sheets. Enable different access levels (Project team, Donors and trading partners) for viewing, analysis and with rights editing member profiles. Membership Subscription Tracking Design a system to track membership subscriptions and payments. Record subscription start dates, renewal dates, and payment history. Allow for online subscription tracking with the flexibility to transition to of...
To help manage my work efficiently, I am in need of a proficient virtual assistant. Using Google Sheets, your initial task entails creating a spreadsheet listing festivals held in Louisiana and Mississippi. This sheet should include: - Festival names - Festival locations - Festival dates Apart from spreadsheet creation, I'll also require assistance with customer service tasks. This role best fits someone that is skilled in utilizing Google Sheets and who possesses excellent customer service skills. Prior experience in a similar role is a bonus, but not a must.
I'm seeking an experienced professional to check and implement our Google Tags, Analytics, and Ad settings for optimization and compatibility with our Squarespace website. The website has less than 10 pages. We do not need maintenance, just assistance with correcting/implementing the settings. If you possess strong proficiency in Google Ads, Analytics and Tag Manager, are familiar with Squarespace, and have a proven track record of similar projects, I'd love to hear from you.
I'm in need of a virtual assistant to help with a variety of tasks, specifically: data entry, email management, and ...virtual assistant to help with a variety of tasks, specifically: data entry, email management, and conducting research. Ideal Skills and Experience: - Proficient in Google Docs and Sheets - Experience in managing email inbox - Can attend video calls and meeting to write MOM with clients I'm looking for someone who can commit to more than 20 hours per week. The ideal candidate should have a basic understanding of Excel or Google Sheets. Your job will be to document data, answer emails effectively, and conduct research on various topics. I am looking for someone who is timely, organized, and detail-oriented. Please reach out if...
In this project, I'm needing assistance to extract text data from printed documents and entering it into Google Sheets. This task involves meticulous attention to detail to ensure the accuracy of the data entered. The project requires a freelancer with strong data entry skills and the following qualifications: - Proficient in Google Sheets and Microsoft Excel - Excellent typing speed - Previous experience with data extraction - Ability to work with printed documents - Good at data categorization and organization - Proven track record of accuracy - Strong attention to detail If you have these skills, please bid for this project. Thanks in advance for your time and effort.
I have a calculator form that needs some updates made. It allows the user to input measurements for an industrial hose to find out settings for crimping. Current form is here: Need to add an option for the user to calculate with Hose Wall Thickness OR Hose ID & OD. Here is a prototype showing how this will work: New page (nee...for an industrial hose to find out settings for crimping. Current form is here: Need to add an option for the user to calculate with Hose Wall Thickness OR Hose ID & OD. Here is a prototype showing how this will work: New page (needs some jQuery updates): Also have Excel with new formula
I'm in need of a skilled freelancer who can deliver a well-rounded Google sheet to capture important aspects of monthly personal finance, it's crucial that the created sheet can be adaptable to handle text, numerical, and date/time data. Key features: - Data validation - Pivot tables - Conditional Formatting - charts/graphs To be a right fit for this task, you should have a strong grasp on creating and optimizing Google Sheets, with these particular functions. Showcasing your past work in similar projects will strengthen your application. I'm looking forward to collaborating with you on this project to create a solid and functional Google sheet.
I'm looking for an SEO expert who can assist in boosting my carpet cleaning business to the first page of Google. Key Requirements: - **Keywords:** The aim is to rank for "Carpet cleaning services", "Professional carpet cleaners", and "Best carpet cleaning company". These keywords are crucial to our business and the expert will be tasked with ensuring they are effectively optimised. - **Targeted Area:** We are currently focusing on targeting the local area. It's imperative that the strategies implemented are able to drive local traffic and visibility. SEO Strategies: - **Backlink Building:** I'm interested in enhancing the backlink profile of our website. The freelancer should have a solid plan for building quality backlinks from reput...
I need to score up my wordpress website in google pagespeed insight. Current score is 38 mobile★70 desktop. Reply Hab in beginning so i can reply. I need asap done this job Note: Remote job Only because i can't give credentials with you
I'm looking for a skilled Google Ads specialist to help me generate leads and sales. Key Responsbilities: - Develop and manage a Google Ads campaign with a focus on Google Search. - Optimize ad copy and targeting to attract local customers. - Monitor campaign performance and make adjustments to improve lead generation and sales. Ideal Skills: - Proven experience in managing successful Google Ads campaigns, with a specific focus on lead generation and sales. - Deep understanding of Google Ads, Google Search in particular. - Ability to target and attract local customers effectively.
