Excel formula if cell contains text then return value in another cell jobs

...information for 25 agencies specializing in scripting video sales letters (VSLs). The task involves sourcing and validating agency names, email addresses, and website links, then recording these details into a spreadsheet. Responsibilities: -Conduct basic research to locate contact information for 25 specified agencies. -Validate that email addresses are current and active. -Accurately enter all data into a provided spreadsheet format. Requirements: -Experience in data collection and validation. -Proficiency in basic research and use of spreadsheets (e.g., Google Sheets or Microsoft Excel). -Ability to deliver accurate results within a set timeframe. -Project Length: Short-term, estimated completion within one week. ( MAX 80 AUD as a test round, ...

I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.

** Please do not apply. If you don’t meet the must have criteria at the beginning of this job description post. We are looking for a motivated and successful grant writer located within Canada! The grant writer will be responsible for locating, researching, and applying for potential funding opportunities in order to ensure successful grant approvals. The Grant Writer MUST be Canadian or have the expertise and experience with the Canadian government, ideally living in Canada and speaks and writes English Fluently. They MUST specialize in IT/digital marketing/ ecommerce/employee hiring grants They MUST have a proven strong track record of total grants submitted vs approvals in the last year within Canada. They are responsible for finding fundi...

I'm looking to capture my family history in a unique and timeless way. This will involve creating a comprehensive documentation of our family history. Additionally, I'd like to have an exact replica of a cherished family T-shirt, which holds sentimental value. Key Requirements: - Replication of Family T-Shirt: I'm in need of a skilled individual who can recreate an exact duplicate of a special family t-shirt. The ideal candidate should be able to produce a high-quality replica with a strong attention to detail. - Skilled in garment replication or fashion design - Attention to detail and ability to recreate a piece accurately Please let me know if you're interested and have the necessary skills for this unique project.

I'm seeking a skilled marketing professional to construct a comprehensive investment offering. This is projected to facilitate the acquisition of an apartment complex in the next 3 months. **We will collaborate on the financial projections, specific business plan, etc. - we need someone who can beautify the hard data (text/financial projections/graphs/maps) and make it digestible to read for a prospective investor. Our end goal is to have TWO forms of this investment offering (a summary teaser that is high-level, and a more granular deck that contains additional detail) that we can recycle on future acquisitions by altering text & numbers without having to re-create the entire pitch** The offering must contain: - Detailed information on the property...

In this project, you will analyze the performance of products within an online retail dataset to uncover insights that can inform strategic business decisions. Leveraging transactional data, including sales revenue, profit margins, and customer reviews, you will conduct a comprehensive analysis to understand the dynamics of product performance over time and across different categories. Through descriptive analysis and visualization techniques, you will identify top-selling products, trends in sales revenue, and correlations between performance metrics. Additionally, you will delve into customer feedback to gauge product satisfaction and uncover areas for improvement. By providing actionable recommendations based on our analysis, you aim to optimize product offerings, enhance ...

I'm looking for a ghostwriter to create a comprehensive guide to intermittent fasting. The book will be in the form of an audiobook, specifically tailored for beginners eager to explore this dietary lifestyle. Requirements: - The book must be expertly written, engaging, and suitable for audiobook consumption. - It should provide a clear, simple, and detailed overview of what intermittent fasting is, its benefits, and how to get started. - I'd like the book to include personal success stories, showcasing various individuals' experiences with intermittent fasting. These stories should add depth, relatability, and motivation to the content. Ideal Skills: - Prior experience in ghostwriting, especially for health, wellness, or nutrition-related content. - Unders...

...create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how to create complex formulas and visual representations of data. - P...

For this project, I am in need of a text-based logo that's designed in a minimalist style with a monochrome color scheme. Key Requirements: - Text-based design: I'm looking for a logo that primarily features the name of my brand or company. - Minimalist style: The logo should be simple, clean, and incorporate minimal design elements. - Monochrome color scheme: The logo should be designed in a single color, specifically in a monochromatic palette. Ideal Skills and Experience: - Proven experience in logo design: A strong portfolio of text-based logos is highly preferred. - Proficiency in minimalist design: Prior experience in creating visually appealing minimalist designs is a plus. - Understanding of monochro...

...primary goal of this campaign is to increase the visibility of my digital products in this particular market segment. I need someone who can effectively communicate the unique value propositions and features of my products to this audience. - **Generating Leads**: In addition to spreading awareness, I want to turn this visibility into tangible leads. The ideal candidate should be able to implement strategies to convert engagement with our brand into potential customers. - **Driving Sales**: Ultimately, the end goal of this campaign is to drive sales for my digital products. Experience in crafting compelling sales copy and executing direct response marketing on Facebook is a must. Ideal Skills: - Proven track record in Facebook marketing for digital ...

...workbook for emerging documentarians. The workbook content will include: - Instructional text - Quotes - Writing prompts - Visual aids (charts, graphs, images) I already have a cover design, mood board, color palette, initial sample layouts, and draft text. I would like a designer to work with me to create templates that I can fill in (either using InDesign or another platform) that will guide my writing and work prompts process. Once I have completed a first draft of the workbook, the designer will collaborate with me to finalize page layouts and manage the printing/production process. Ideal Skills and Experience: - Experience in designing workbooks and workbook templates. - Proficiency in graphic design and layout software - Ability...

I am looking for someone experienced in web scraping and data collation. The project will involve scraping blog articles in HTML format and compiling desired information into an Excel file. Key Project Requirements: * The extraction will be from specified URLs, using their individual patterns for efficient and accurate scraping. * For each blog article, I need the title, the full text, and the publish date extracted. * This scraped data must be properly arranged in an Excel file for easy analysis. * List of articles is here: Ideal Candidate Expertise: * Proven experience in web scraping is a must, preferably with full understanding of HTML structures. * Proficiency in Excel and data organization. * Attention to detail to en...

I would like to design standard operating procedure (rules of lead engagement) based on large medium and enterprise segments- 1) how should sales consume the leads once a lead is assigned to the sales reps. 2) Define the stage movement timeline from one stage to another in salesforce based on which stage the lead is in. 3) How long to wait to send a follow up email /call after the two way connection has been established. 4) Reason to close or recycle the lead 5) Activities logged in salesforce. etc.

I NEED TO ANIMATE MY LOGO FOR YOUTUBE, IT WILL BE USED FOR INTRO AND ANOTHER ONE TO PASS IT IN INTERMISSION- Basic but professional and pretty!!!

...assistance in determining a sound pricing strategy, setting appropriate initial prices, and conducting a thorough analysis of competitors' prices. Additionally, I'm at a point in my business where I haven't yet defined my customer segments. Key services required include: • Formulating a pricing strategy for my digital services. • Setting the initial pricing for these services. • Analyzing and making recommendations based on competitors' prices. • Guidance on customer segment definition for optimal pricing. I currently make use of various pricing methods including cost-plus, value-based, and competitor-based pricing. Therefore, I need a professional who has a deep understanding of all these methods, preferably with a backgr...

I'm seeking an experienced designer who can help me create a unique and engaging di...ensuring it resonates with the target audience - We need to maintain a balance between entertainment and educational aspects as this is a diary book themed channel Ideal Skills and Experience: - Proven experience in designing YouTube channel mockups - A creative flair for creating visually appealing designs - Previous experience with designing for vlogging, educational, or entertainment channels is desirable, especially for a diary book theme - Familiarity with the current trends in YouTube channel design - Ability to create designs that balance entertainment and educational value If you're a designer who can help me bring this vision to life, I'm excited to...

I need to produce video focusing on the boxing process of JBL LiveFree 2 TWS earbuds. Key requirements: - Highlight packaging quality, contents included in the box, and the first impression of the product Ideal candidates for this project would be those with experience in product video production, particularly in the electronics field. A good understanding of consumer electronics, especially earbuds, will be an added advantage.

I need you to produce either the voice of the MAN or the WOMAN for an audio recording of a few lines. This audio is for a low-budget, serio-comic film. It may be used in another film as well. IMPROV ENCOURAGED! PLEASE REMEMBER: You are asked to record either the voice of the MAN or the WOMAN. FULL DISCLOSURE: This film has other scenes that I am sure will be considered offensive to many women and Christians, although others viewers may see it as raising valid theological and social issues in an original, cerebral, educational, high-concept, albeit edgy comic venue. (Your scene is not comparatively controversial in that respect). Your role would be either the man or the woman. ...

Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good...

I'm in immediate need of a cloud-based stock management software with barcode generation, scanning, stock quantity tracking, and weight measurement functions. The system should enable me to: - Generate and scan barcodes for every product in my stock - Track the quantity of each item I have in stock - Measure the weight of my stock in grams I prefer a cloud-based solution that can be accessed and updated from any internet-connected device. The software should have an easy to use interface and be able to: - Enable manual entry of stock data - Support updating stock information by scanning barcodes - Automatically update stock data from my sales records The software could be developed in Excel, as long as it's accessible online. As a fre...

I need an Excel sheet created with the primary purpose of data analysis. This sheet should have the following features: - Data Sorting and Filtering: This is crucial for making the analysis process efficient and easy to navigate. I need the sheet to be able to handle large amounts of data and allow for quick and convenient sorting and filtering. - Data Visualization: In addition to the data analysis, I also require the sheet to include line graphs. I believe that visualizing the data will make it much easier to understand and interpret. The ideal freelancer for this project is someone with a strong background in Excel and experience in creating data analysis tools. It is important that the final product is user-friendly and has a clean, professional ap...

I'm in need of a freelancer to assist with data cleaning from PDF documents. The task involves organizing the data into an Excel spreadsheet. Ideal skills for this role include: - Proficiency in data cleaning techniques - Strong attention to detail - Proficient in Excel for organizing data - Previous experience in similar data entry tasks

I'm seeking a smart freelancer based in the USA who is having a local cell phone connection and are capable of making calls to gather information.

I'm looking for a developer to create a simple starter trading script. This is can be based on another script and does not need to be written from scratch. Develop a simple script that buys a particular cryptocurrency when it drops X% and sells it when it recovers Y%. Once that is established, we can look at adding the usual trading indicators as part of the strategy, but I want to start basic. Ability to customize buy and sell points as well as add different cryptocurrencies. Very Important: Host the script in the cloud for convenience and to avoid personal management responsibilities. I don't want the script to run on a server like AWS that I'd have to manage and continually monitor for uptime, etc. The script should allow for easy parameter adjustments...

I want to scrape daily leads from LinkedIn Jobs, Indeed Jobs, , etc. The task involves extracting data from these job sites and exporting it to Excel sheets. It would be preferable to have some kind of automation that reduces human dependency in obtaining leads every day. If someone has already set up a similar process before, I would prefer that. Preference will be given to those who have previously performed lead extraction tasks for recruitment websites.

...Responsibilities: - Create and manage two distinct campaigns: one for follower growth and another for boosting product sales. - Deliver a minimum 5x ROI, substantiated with past client results. - Target the campaigns with precision towards my specific audience. The ideal candidate should have: - Proven track record of managing successful Facebook and Instagram campaigns. - Experience in creating and executing campaigns that target multiple goals. - Ability to provide evidence of delivering substantial ROI for past clients. - Strong analytical skills and the ability to interpret data to optimize campaign performance. - Excellent knowledge of social media advertising tools and platforms. If you're confident in your ability to deliver on these objectives...

I'm in need of a captivating video advertisement aimed at boosting sales for my e-commerce store. While I have no specific target audience outlined, the candidate with a broad understanding of different demographics will be highly preferred. - The Work: The scope of work will include concept creation, creating storyboards, filming, and post-production. Your work should deliver a compelling narrative that encourages the viewer to make a purchase. - Ideal Skills: You should possess demonstrable skills in video production and editing, storytelling, and e-commerce marketing. Past experience creating effective e-commerce ads will be highly beneficial. - Timeframe: There's no rush to complete this project. I do value quality over speed, so take the time yo...

I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-fri...

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

I am in need of an experienced Vue.js developer who can quickly fix my Vue 2.6 application. When I click on a button to go to another page it works fine in development but when I deploy it gives a 404 error. I need this fixed as fast as possible. When you respond to this posting please put "I CAN DO IT" at the beginning of your bid. I don't want to waste time with automatic bids that nobody answers. And please bid honestly and not low ball then ask what's your budget. I will upload the project when I find a person

...complete this task; we can leave each other nice comments and 5 stars for each? Look at feedback on my profile, feedback I left for many others. Here is the project: SINCERELY WOULD BE NICE TO MEET YOU PLEASE ANY THOUGHTS ? Please note project is due in two hours as this projects deadline, as this is needed if we can get some done - then we can talk about next steps and 5 stars and another job also. If this is a good one and we are "successful"; would need a couple others setup, but will handle one at a time? Can you do this for something reasonable in a couple hours? thoughts ?...

...animator to create a 1-minute video. The project involves animating both characters and objects in a realist style for a vertical format. Key Requirements: - The video should be 1 minute long. - The style of the characters should be realist. - The objects to be animated are a spaceship and the brand's mascot. Ideal Skills and Experience: - Proven experience in 3D animation, particularly in realist character design. - Strong portfolio of previous work that demonstrates your ability to animate objects like a spaceship. - Prior experience in creating content for vertical format videos would be beneficial. - Excellent communication skills, as I value clear and prompt communication throughout the project. If you have the skills and experien...

I need a proficient Matlab Simulink professional to simulate the current production in a semi-truck's solid oxide fuel cell. This should take into account multiple variables, specifically: - Temperature - Pressure - Fuel flow rate These should be varied at high levels in the simulation. With a requirement for medium precision, the model should sufficiently represent the real-world scenario without too much granularity. The goal is to understand how these variables affect the current production. The ideal candidate should have a strong background in thermodynamics, system simulations, and Matlab Simulink. Experience in solid oxide fuel cells and vehicular simulations would be a significant advantage.

...experience in recapitalization efforts. Key tasks for this project include: - **Valuation Analysis**: I need someone who can perform a thorough valuation analysis based on the financial data available. - **Debt-to-Equity Ratio Calculation**: The ideal candidate will be able to calculate the current debt-to-equity ratio and provide recommendations for improvement. - **Return on Investment Analysis**: A comprehensive ROI analysis is necessary to evaluate the potential outcome of the recapitalization effort. I have all the relevant financial data in hand, so the focus will be on the calculations and recommendations based on this data. The primary goal of this recapitalization effort is to restructure the company. The perfect candidate for this project should posses...

Please Sign Up or Login to see details.

I'm in need of an experienced mobile app developer with proficiency in PayPal API integration. The app is intended for an adult audience and the key functionality will be payment processing. Ideal Skills: - Experience in cross-platform mobile app development (both Android and Apple) - Expertise in PayPal API - A clear understanding of secure payment processing - Code Review will be carried out as part of the testing process Expected Output: - A smooth, intuitive cross-platform app - Seamless and secure payment processing utilizing PayPal. Candidates should have a strong portfolio showcasing similar projects. If this sounds like you, please bid with your plan of action and expected timeline. The Project: There is a requirement to develop a pie...

...me gifts, I want to use my video projector to put in the background a boss that I have to defeat, people should have to give me gifts so I can defeat it, I'm looking for a skilled Android developer to create a simple but interactive final boss health bar app for my phone (I already know how to mirror my phone on the projector) . This health bar should decrease in size by 1pt, with 5000pts as the initial starting value. The bar should be responsive to either my voice or simply recognise the value of the gift I receive on tiktok live or to clicks/taps, (ideally the interaction have to be with my voice or recognise the gift value on tiktok live but if not possible it can be clicks or taps on the screen). The app should have a soldier image ...

...certain character features of our staff. For example brown hair, 5"4 female. of male 6'2 blonde. I then send a availability check to work on certain dates and if they agree i send their profile to the production for approval. The approved staff then get added to a whatsapp "mailing list to communicate with as a group but each person receives a private message. - Contact List Management: I also need the CRM to have a robust Contact List management system, to help keep track of our clients and their interaction history, invoice and wages timesheets but this would be intergrated with another program i expect. Ideal Skills and Experience: - Proficiency in WhatsApp API and CRM development - Experience in creating survey systems that ...

I need a mature American male voiceover artist & music for an explainer video - Ideal candidate should possess a Senior (50+ years) voice - Previous experience in radio voiceovers is a must Similar style to storyboard/script and blocked video Similar style to another just completed

I'm seeking an experienced professional to help me craft a ...stage. Key Responsibilities: - Drafting an investment proposal that succinctly and effectively communicates the value of the business - Ensuring all required business information is included - Presenting the business model, growth potential, and financial details in a clear and persuasive manner Ideal Skills & Experience: - Proven track record in writing successful investment proposals - Previous experience in the Food and Beverage industry - Understanding of the Growth stage requirements for businesses - Strong financial analysis and projection skills Your role will be crucial in attracting potential investors to take an interest in our business. If you&#...

...meticulous freelancer to perform an easy yet detailed-oriented task: transferring specific technical text content from a document to another platform. Here's what you should know: - You'll be handling purely text content. No images or URLs to worry about. - The text content is technical in nature-detailed and specific. What skills and experience should you have? - Excellent attention to detail: The content's technical nature means there's no room for errors. - Familiarity with handling technical content: A background in technical writing or similar is a plus, but not strictly required. - Proficiency in English: While you won't be creating content, reading and understanding the technical text is vital. -...

Project Overview: I am seeking assistance in integrating image links into two Excel sheets containing a total of 620 and 46 product entries for my Shopify store. Each entry includes links to the official websites where the products are sold. The task involves creating a new column labeled Images in both Excel sheets and inserting corresponding image links. This integration is crucial for ensuring that when uploading a CSV file to Shopify, each product will display its respective images seamlessly. Project Details: Scope: Adding image links to Excel sheets for 666 products in total. Task: Create a new column labeled Images in each Excel sheet and insert corresponding image links for each product. Requirements: Image links should open t...

I'm on the lookout for a professional well-versed in text data entry. The ideal candidate needs to: - Be proficient in entering text data accurately - Ensure data integrity and meet strict deadlines - Manage a sizable workload—around 100 to 500 pages Previous experience with large volume text data entry would be an asset. Efficiency and attention to detail are must-have skills for this job.

I'm on the lookout for a professional well-versed in text data entry. The ideal candidate needs to: - Be proficient in entering text data accurately - Ensure data integrity and meet strict deadlines - Manage a sizable workload—around 100 to 500 pages Previous experience with large volume text data entry would be an asset. Efficiency and attention to detail are must-have skills for this job.

I am looking for a skilled tax professional to file my 2023 annual personal income tax return with the Mexican IRS. This project will involve handling income from wages/salary and deductions anything. Ideal Skills and Experience: - Proficiency in Mexican tax laws and regulations - Experience in filing personal income taxes, particularly in Mexico - Knowledge of deductions for educational expenses - Excellent attention to detail - Ability to ensure compliance with all relevant tax laws and optimize refunds Please note that tax optimization strategies for future filings are not required for this project.

When button clicked, the field of another table will changed to required. Only FTP no cpanel

Just like the title says, i currently have a script on my site that displays text on mouse over, just not sure why it wont let me add line breaks; i can not give you access to the site, but i can send you the script. I have tried adding... '<br>, n, b, ' not really sure why its doing it. Thanks,

I'm looking for a competent Java developer to assist with the development of several data structures and algorithms. In this project, you will conduct a set of experiments to compare the performance of dictionary implementations that use unsorted arrays vs. sorted arrays. You are given the Dictionary interface () and its implementation class (). In addition, the file contains a list of 10,000 key-value pairs that represent certain measurements. Key Skills: • Expertise in Java programming • Extensive experience with diverse data structures and algorithms • Ability to adapt to fluctuating project requirements Your ability to create powerful, flexible systems with Java will be crucial for this undertaking. Though the

Design and implement one page website. The website shall have a design similar to the included "reference ". Please also notice the "reference " which contains a mockup of the top part of the website and the color scheme. The top menu contains links within the same page (anchors), so only one page, no sub pages. Notice that the hero area is a photo carousel consisting of multiple photo. The carousel must change the picture automatically every 3 seconds, but also have controls to change the picture with clicking. The photos to be used on the website are attached. Also the text to be used on the page is included. The implementation must work with any browser size, including mobile devices. The implementation must work with Chrome based browsers bu...

I would like a drawing of a photo of my mother and my grandmother on her wedding day with a view to add myself in after my wedding day (can return the picture to add the extra person) More details: What style of portrait drawing are you looking for? Realistic Should the portrait be based on a photograph or do you prefer a live session? Based on photograph Would you like the portrait to be drawn in colour, or would you prefer black and white? Black and White