Vlookup add formula jobs
...conditions. In this case, the cells should be highlighted based on containing certain text. Skills and experience required: - Proficiency in Microsoft Excel is essential. - Familiarity with conditional formatting in Excel to highlight cells. - Experience working with text-based data in Excel. - Attention to detail to ensure the correct text is highlighted. I need a quick or instant way either with a formula or conditional formatting to find where each of the values in this column are located in the bordered areas, and then highlight those specific cells. Basically I am going to a website, downloading a long list of parts with individual numbers and then need to be able to quickly search all of those numbers in my excel spreadsheet all at once and highlight those cells instead o...
...developer who can create a Xenforo add-on that replicates registration data into an additional database. Here’s what the project involves: - Functionality: The add-on must copy user registration data from Xenforo into a separate database (for a start a simple sqlite3 file database). The password must be hashed and salted, similar to MyBB standards. ( this requires us to do it on every registration attempt because we only have the plaintext password at that moment and can only create a MyBB hash and salt at that time. Must Have: Xenforo Add-on dev env. I don't want to have to give you my license key for your xenforo development Ideal skills: - Xenforo knowledge: It's essential for you to have prior experience working with Xenforo software to ensu...
... Manipulate data, perform calculations, and generate reports using advanced Excel functions. Analyze and interpret complex data sets to provide valuable insights. Develop and maintain Excel templates and spreadsheets for organizational use. Collaborate with team members to ensure timely completion of projects. Requirements: Proficiency in Microsoft Excel, including advanced functions such as VLOOKUP, INDEX-MATCH, and PivotTables. Strong analytical and problem-solving skills. Attention to detail and accuracy in data management. Ability to work independently and collaboratively in a team environment. Excellent communication skills. Preferred Qualifications: Experience in data analysis or related fields. Familiarity with other data analysis tools and software. How to Apply: If you...
btw, the bachelor party will be in Dallas and the text is a reference to this movie: (not sure how well-known the movie is) Debbie Does Dallas - Wikipedia
Must know wordpress and woocommerce. Must have access to a computer
I'm looking for a software that can be designed within Excel to track daily sales and present a detailed profit calculation per liter of petrol. Key Features: - Dail...detailed profit calculation per liter of petrol. Key Features: - Daily Sales Tracking: The software should enable manual entry of daily sales figures for accuracy. - Profit Calculation: The software should generate a detailed report on profit per liter of petrol sold. - Remining fuel in tank also show - calculate auto profit in the tank Ideal Skills: - Proficiency with Excel including advanced formula writing, data organization, and report generation. - Understanding of petrol pump operations and metrics. Note: While the project is to be developed in Excel, suggestions for potential future software integrati...
I'm looking for an excel expert to help build and format an advanced product database for the services industry. I already have an existing excel spreadshee...format an advanced product database for the services industry. I already have an existing excel spreadsheet with many items already programmed so this will just be added on. This will revolve around three main components: -Product database containing items -Drop down menu to insert products from database -Custom Graph A strong working knowledge of Excel features, particularly Pivot tables, VLOOKUP function and conditional formatting is a necessity. It would be ideal if you also have experience in data management for the services industry. Your expertise will enable the creation of an effectively organized and easy-to-m...
I'm looking to engage with a skillful Excel whiz who excels (pun intended) in a variety of Excel formulas. In particular, I need someone who has proficiency in: - Average and standard deviation for each part - Average and standard deviation parts total by invoice - Average and standard deviation trip charge - Average and standard deviation Material markup % - Average and standard deviation Hours - Average and standard deviation Installation labor - Average and standard deviation Non-installation expenses - Average and standard deviation Other fees - Average and standard deviation Freight
I am trying to develop a C# add-in for personal use, but I'm having troubles getting it to work correctly. It seems like my troubles lie somewhere in the packages I'm using or how my project is configured, so this could be a pretty easy fix, but I'm not sure. I'll provide you with the code I have, which should theoretically already work, and all I am asking is that you can get the code to run, send me the Visual Studio project, and I am able to run it on my own system. Here's my end goal for the project, just to give you a better idea, however you won't have to do this, I'll describe what I need done in the next paragraph: Open excel, button in Excel add-in that you click, opens file explorer, you pick a local document on your system, it wi...
I'm looking for a skilled video editor to transform my less than 2 minute Formula 1 footage into a fast-paced exciting and engaging Snapchat video that includes energetic transitions, music overlay, and special effects. Key Requirements: - Expertise in video editing, particularly in a thrill cars fast-paced style. - Previous experience in editing Formula 1, race track style sports or action-related content is a plus. - Proficiency in adding music overlays and special effects to enhance the viewing experience. The final video needs to capture the essence of a Formula 1 experience - the speed, thrill, and excitement, while maintaining an engaging narrative flow. A keen eye for detail and ability to synchronize energetic transitions with the music and special effe...
I want a formula in column D of the attached spreadsheet to convert the date in column C to DD/MM/YYY
I'm looking for a Google Sheets expert who can create formulas, automate data calculations, and provide data analysis and reporting. The successful freelancer will need to automate data input from a website or database. Ideal Skills & Experience: - Proven expertise in Google Sheets, particularly in formula creation and automation. - Experience in data analysis and reporting. - Demonstrated ability to automate data input from websites or databases. - Strong communication skills and ability to provide detailed project proposals.
An existing STL model needs some updates and I would like to have the STL modified and the 3D file More details: What specific changes do you want to make to the STL file? Adding new features What type of new features do you want added to the STL file? Aesthetic designs What type of aesthetic designs are you thinking of incorporating into the STL file? Modern-style design
...developer to create a Microsoft Word add-in that can perform a variety of operations on PDFs. This add-in should offer: - A SaaS Gateway - A list of relevant PDFs based on the text typed into Word, further improving workflow. - A way to view and preview the searched PDF files directly within Word. - The ability to duplicate and combine selected PDFs into a new PDF. - Additional functionality such as automatically numbering the pdf and renumbering it whenever additional pages are added to the pdf. . This add-in should be compatible with both Windows and Mac operating systems. As far as the look of the add-in, it should match Microsoft Word's theme to maintain consistency and seamless user experience. Ideal applicants should have a proficiency in develo...
...monthly rental fee for equipment. The JavaScript function you develop should be able to replace the existing Excel macro that uses Goalseek. - Data Handling: The function should be designed to receive input data manually from the user. This means that the function should be able to take in data directly from the user, process it, and return the calculated rental fee. - Complexity: The current formula used in the Excel macro for calculating the rental fee is moderately complex. It involves elements such as interest rates and amortizations. The JavaScript function you create should be able to handle these complexities and produce accurate results. Ideal Skills: - Proficient in JavaScript and algorithmic problem-solving. - Experience with Excel macros and Goalseek is a plus. - St...
We are going to add a new page in your existing website based on the details provided by you in the document. Along with this we will also change look of testimonial section on home page. We also have to update social media logo icons with latest updates of logos.
I need a proficient Excel specialist to provide immediate support with data analysis, automation, and formula creation. Your expertise is essential in transforming a specific data format from '111111111111' to '' in Excel. I just need for someone to show me how to do it so I can replace it in my Excel database
Bro, If the entire website needs to be done, then this project's price will differ, but now previous work milestones have been created.
I'm looking for an experienced Excel expert to assist with my data analysis and formula creation tasks. - Data Analysis: I need you to help me with both statistical and financial analysis. It's essential that you are comfortable and proficient with these kinds of data analysis within Excel. - Formula Creation: You'll also be responsible for creating various formulas, particularly related to budgeting and financial forecasting. Experience in working with such data to build accurate and efficient formulas is a must. I'm looking for someone who can quickly understand the data, provide insightful analysis, and create the necessary formulas for financial tasks.
I'm looking for a graphic designer to create a trendy and eye-catching design for my t-shirt, focusing on the latest trends in car sports. The design should incorporate elements of Formula 1 racing, soccer, cricket and sports cars in a way that is stylish and appealing. Key Requirements: - Proficiency in graphic design, particularly for apparel - Understanding of the latest trends in car,sports - Ability to creatively incorporate Formula 1 racing, soccer,cricket and sports cars into a cohesive and attractive t-shirt design It's important that the design is not only visually appealing but also resonates with fans of car sports, as well as those who appreciate the latest trends in sports. Experience in designing for apparel, particularly t-shirts, will be highly val...
I need two new pages incorporated into my existing website, specifically focusing on cocktails. These pages are "Cocktails" and "Selected Cocktail Recipe". "Cocktails" Page: * Information required for this page includes vivid cocktail images and engaging cocktail descriptions. * I already have a Figma outline representing the desired page layout; your role would be to transform this design into a ready-to-upload Wordpress format. * As shown in the Figma, the cocktail images should be displayed in a particular layout. "Selected Cocktail Recipe" Page: * The nature of the content for this page will be communicated later on. The ideal freelancer for this job will have a deep understanding of web design, proficiency with Wordpress, expertise using...
We need 48 picture cards. The card game involves building stories with children during therapeutic sessions. A child chooses a card from each theme and tells a story with these cards. For example the hero is a b...wicked witch Find a treasure Free a princess Heal the sick king Catching a fiery horse “Emotion” Cards (emoticon) Sad Fear Anger Unfair Worried Disgust Joy Love “The unexpected friend” cards Knight Fairy The mysterious child The good genius The good magician The golden unicorn Princess The good witch “Power” Cards A precious stone The magic potion The magic wand The flaming sword The magic formula The magic mirror The golden key The Cape “Adventure Location” cards A castle A planet An enchanted forest A cavern A ship The...
I need a customised Google Sheets add-on that connects with the multiple ad account platform APIs to retrieve specific advertising data. Specifically, I'm interested in: - Retrieving all relevant ad related metrics that the APIs provide that will be selected from a menu add on extension for Google Sheets. Project needs completing within 1.5 to 2 months from start date. The aim of the project is to automate the process of fetching these data, reducing manual efforts and time for users. Ideal freelancer should have: - Profound knowledge of Google Sheets Add-ons - Experience with multiple Ad Account APIs - Understanding of Advertising metrics - Ability to deliver a clear, easy-to-use interface within Google Sheets. Success for this project means p...
This is a one of project; I'm looking for an Excel expert to develop a workbook enabling data analysis of multiple bank and credit card statements. This workbook must have the ability to run multiple functions/reports - Implementation of SUM and COUNT functions. - Utilization of VLOOKUP or HLOOKUP. - Creation of Pivot Tables and informative Charts. The ideal candidate would be someone with prior experience in financial analysis or data engineering, who can ensure that the workbook provides the insights needed. Ability to ensure accuracy and relevancy within the formulas and functions is essential. Attached is a sample data file. This is a pdf to excel conversion. Prior to submission, the conversion data will be sanity checked and verified. If an alternative format or lay...
I'm in need of a skilled developer who is adept in .net SDK and C# to develop an add-in for ArcGIS on the Windows platform. - The key functionality required for this add-in includes data serialization, network communication and database interaction. - Specialized experience in .net SDK and ArcGIS is highly appreciated. - You'd be expected to make this add-in compatible with Windows. Incase you've developed for this platform in the past, kindly highlight so in your proposal. An ideal candidate would be quick to understand requirements and deliver a clean, efficient solution. Looking forward to your bid.
...containing task information and sends data to designated webhooks for automated notifications. It also auto-extends deadlines when required Project Objectives: Webhook Automation: Trigger webhooks to send data to specific endpoints based on conditions such as due dates and task status. Auto-Extension: Automatically add extensions to task deadlines when conditions are met, providing flexibility for users. Error Handling and Logging: Ensure robust handling of date parsing and add logging for tracking script execution and diagnosing issues Key Components Google Sheet Structure: The spreadsheet contains task-related data, including (Column Names): Task Name (fixed data coming from a third party form) Notes (fixed data coming from a third party form) Due Date ("Fixed Da...
Update the changes to calculator form according to new prototype with updated formula
Looking for an experienced web developer who can take my Google Sheets table / Excel spreadsheet with the custom formula and turn it into an engaging, dynamically updatable and nicely styled website which I can embed into multiple sections of my WordPress site. Skills and Experience: - Proficient use of WordPress - Extensive experience with website development and design - Sound knowledge of Google sheets and its functionalities - The developer should be able to make the sheet customizable and allow for data updating. Please include your experience relevant to the job as part of your application. Don't worry about showcasing your past work or drafting a detailed project proposal - your background in web development and WordPress is what's most important to me. Not...
I need an experienced developer to extend my existing PHP SQL driven platform. This project revolves around adding innovative features to the current structure. . Your job will include: - Analyzing the current structure and proposing alterations to accommodate the new functionalities robustly. - Implementing these suggestions after my approval with special emphasis on maintaining the overall performance & responsiveness of my website. To be an ideal fit for this project, you should: - Have previously worked on expanding PHP SQL based platforms. - Be capable of producing detailed project proposals. Apply with your most detailed project proposal, including your understanding of this task, estimated timeline, milestones, and why you think you're suitable for this role. I look ...
I'm in need of a proficient Excel and Word expert who can assist me with various tasks. Unfortunately, I did not specify the exact tasks nor provide a deadline for this project. However, I'm excited to review your proposal and discuss your experience in more de...discuss your experience in more detail. Please include your past work in Excel and Word with your proposal. This could be anything from template creation to complex data analysis and automation. The more detail you can provide about your past work, the better. In terms of my needs, I'll be looking for a flexible freelancer who can help out with a range of tasks. Experience in data analysis, formula creation, and automation in Excel would be particularly desirable, as would proficiency in creating and form...
...Excel for further analysis. Graphs Per Department: - **Data Points:** The graphs should focus on data from Sales, Expenses, Profit, and Number of Employees, using a rolling average approach for accuracy. - **Rolling Average Calculation:** The rolling average for the graphs should be calculated based on Manual Entered Data, per department. Additional Requirement: - **Formula Calculations:** The website should also support formula calculations for further analysis as requested by the admin. Ideal Candidate Profile: - Proficient in web development with experience in creating data-driven websites. - Familiar with graph creation and data visualization tools. - Good understanding of user access management and data exporting. - Able to implement rolling average calculations ...
I'm having a significant issue with my Google Sheet that needs sorting quickly. The main issue I'm dealing with is a formula error - when I try to make a hyperlink auto-populate after inputting a specific exercise, it just isn't working, which is causing a lot of frustration. Key Requirements: - Understands Google Sheets - Skilled in fixing formula errors - Fast turnaround time Ideal Skills and Experience: - Strong expertise in Google Sheets and formulas - Proven troubleshooting evaluation - Ability to deliver ASAP.
Simple task: Add ready made ai prompts section based on given static array of prompts existing chat UI (Reactjs)
I'm searching for a skilled Python developer to create a specialized module within Odoo 15. The module will connect to a web service for publishing and authorizing invoices. The resulting response should be stored in Odoo. Key Deliverables: - Programming a specialized module within Odoo 15 - Proven Compliance with all the guidelines of the authorizing web service on a test environment Ideal Skills and Experience: - Proficient in Python programming language - Familiarity with Odoo 15 and its module development - Prior experience in developing web services for enterprise applications - Understanding of invoice management systems, especially within ERP contexts. Spanish is a plus for this project.
immediate task, dev should be available at 1AM today Indian Time to implement and test the function in our script on Anydesk. Budget : max budget INR500, bid amount for entire task and not hourly 1. Add email notification on new booking to admin and lawyer (mail function already there) 2. Add pusher notification on new booking to lawyer (pusher notification function already there) I need assistance to swiftly add a new email template into my Laravel-based Codecanyon script. This concerns a booking email. Here are the specific details it should contain: - Booking date - Booking time If you're an experienced Laravel developer, capable of smoothly integrating new features into existing projects, this task will suit you. A strong understanding of email template...
You have to add around 8000 articles from a supplier website to the Shopify website. It can be provided a list with the sku. You have to add text, description and pictures.
I am looking for someone who can help me correct some formulas and formatting errors in my Excel spreadsheet. - The spreadsheet contains Sum and Count formulas that need to be fixed. - There are also formatting errors that need to be addressed. Ideal skills: - Proficiency in Excel - Experience with formula correction - Attention to detail for formatting errors.
I am currently experiencing some issues with a Google Sheets array formula that is pulling the wrong data from columns G, H, I, and J. I need a skilled and experienced freelancer who is adept at Google Sheets formula manipulation to help me rectify this. Here is what needs to be done: - Identify why the formula is pulling incorrect data and address the issue. - Correct the array formula such that it accurately matches and places data from the correct columns. Deep understanding of array formulas and error troubleshooting in Google Sheets is a prerequisite for this project. An ability to work quickly and accurately is also key.
As an organization focused on understanding our customers better, we are in need of an Excel tool that is designed to handle customer data. Specific functions needed are: - Advanced calculation and formula functionality. You should be adept in creating and troubleshooting complex Excel formulas. - Data Visualization: Ideally, you should be skilled in creating efficient and easily interpretable Bar Graphs. This is how we'd prefer our data to be visualized. Key skills and experience: - High-level proficiency in Excel - Demonstration of designing efficient data visualizations in Excel - Ability to work with customer data effectively. A comprehensive understanding of Excel, including experience with customer data analysis, will position the chosen freelancer for success in this...
We offer an exciting 50/50 monthly revenue partnership that allows you to refer clients to our payment processing account specialists. Our unique approach involves providing your clients with a comparison formula that highlights any overbilling in their current processing statements. By setting competitive rates, we help merchants save substantial processing fees. Additionally, most merchants who opt for the new surcharge program in the USA (and recently in Canada) receive state-of-the-art equipment replacement for free. The successful referral will be a client who signs up for a POS system and payment processing services. Please provide a quote for setting up this system and indicate your experience with similar projects.
I'm in need of a proficient developer who can craft a Firefox Add-On in JavaScript. The primary function of this add-on will be to leverage the capabilities of the Open AI API. Key Points: - The add-on should be developed in JavaScript for the Firefox browser. - It should be designed to interact with the Open AI API. Please get in touch if you believe you're equipped to handle this task.
...of how the process works, from the reporting of a crime, to the eventual match/no match on the DNA database. b. Identify any conditional aspects of the process, for example if there are any stages of the process where resources only become available once the previous sample has been processed. c. Second, write out the relevant equations associated with each step of the process, and construct a formula for the overall time in system. d. Use relevant notation and write out equations using Equation Editor in Word. e. Note – the rule of thumb is that any reader can pick up your report and replicate your results by following the methods. 2. Use mean values of each parameter to construct an “average” solution. a. Unit of interest – a DNA sample collected by a CS...
I'm in need of an expert to help me with two things: debugging my WooCommerce Product Add-On plugin and modifying its layout. Specifically, I'm experiencing glitches and errors with the plugin and seeking someone who can identify these issues and correct them, ensuring the plugin works smoothly. As for the layout modification, I'm aiming to change the current layout of the add-on options. The new layout should display these options in a dropdown menu. Ideal skills and experience for this job include: - Proficiency in WordPress and WooCommerce - Strong debugging skills - Experience with customizing WooCommerce Product Add-On plugin - Understanding of UX/UI best practices, especially in e-commerce environments - Ability to implement a dropdown menu fo...
