Excel formula to compare two columns and return a value jobs

We are seeking a Business Data Analyst for our team who is willing to work with new beginners in the field. As a Business Data Analyst, you will be responsible for analyzing large datasets, interpreting trends, and providing insights to drive business decisions. The ideal candidate should have a strong analytical mindset, excellent problem-solving skills, and the ability to work collaboratively with a diverse team. Responsibilities: - Collect and analyze data from various sources - Identify patterns, trends, and correlations in datasets - Create reports and dashboards to present findings - Collaborate with cross-functional teams to understand business requirements Req...

I'm looking for a Virtual Assistant to grab leads, I’ll send material on how. It’s pretty simple. We'll specifically be targeting those who work in the nightlife industry and going down the research rabbit hole on Instagram. Ultimately I'm trying to sell high end social media services and night life people have access to a wealthy Rolodex so my goal is to gain a bunch of affiliates from this. Key Responsibilities: - Find mini partners (affiliates) in nightlife: vip hosts, promoters, club managers club partner companies, etc. - Inputing the above prospects info (names and emails) on a google excel sheet Skills and Experience: - Fast - Critical Thinker - Proficiency in usi...

I am seeking a proficient Excel expert to build a multifunctional sales proposal tool. The core functions include: - Entering Data: The tool should accommodate efficient and easy data entry from multiple source files. If this can be automated that would be preferable. - Sales Calculations: The tool must have the ability to perform various sales calculations and convert source files from multiple currencies to GBP - Templates: I require outputs to integrate into existing Excel templates for generating client proposals, producing invoices, and confirming projects. - Automation: Desired features include automatic data sorting and automated calculations to streamline and simplify tasks. - I have...

Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.

I need assistance with a data entry project. I have a number of records that need to be accurately typed into an Excel sheet. - The data to be entered is fairly straightforward and doesn't include complex formulas or calculations. - You won't be required to do any data analysis or validation. - Unfortunately, I don't have the exact number of columns or rows, but it's a moderate amount. The ideal freelancer for this project will have: - Proficiency in Excel and data entry - Attention to detail and accuracy - A commitment to meeting deadlines Your main task will be to ensure that all the details are accurately recorded in the Excel sheet.

I require a professional freelancer with extensive experience in Microsoft Office 365 to develop a set of Word, Excel, and PowerPoint templates for my business. Key Details: - Each template needs to incorporate our company's logo, color scheme, and slogan in a visually appealing manner. - I am looking to have 1 to 3 distinct templates created for each platform – Word, Excel, and PowerPoint - so I need someone versatile and creative. Ideal Skills: - Strong knowledge of Microsoft Office 365 - Graphic Design Skills - Branding Experience Please provide some examples of the branded content you have created in the past, especially any corporate identity materials. Looking forward to...

...seeking an Excel expert to help with a data analysis project. The spreadsheet is set to a high level of complexity, requiring a mix of data analysis and data cleaning tasks. Key Tasks: - Data Analysis: I need someone who can set up the spreadsheet as a dashboard, and perform data analysis tasks. - Data Cleaning: You need to handle the data cleaning part of the project. This involves removing duplicates, handling missing values, and standardizing data formats. The ideal professional for this job will be experienced in: - Advanced Excel functions, including data analysis and building dashboards. - Proficient in data cleaning techniques. - Able to work with complex data sets. The project wi...

I need to extract text and tables from a series of PDFs and convert them into an Excel file. The main requirements for this project include: - Extracting text: The texts from the PDF files need to be carefully extracted and placed into the corresponding cells in the Excel sheet. - Tables: There are some tables within the PDFs that need to be accurately reproduced in Excel. The Excel file must preserve the original formatting of the text and tables, so as to maintain the integrity of the data. The PDFs are only in English, so no complex multilingual extraction is required. Ideal Skills: - Proficiency in PDF to Excel conversion - Strong attention to detail - Ability to...

I'm in need of a senior-level appointment setter with a solid background in B2B sales, specifically in the telecommunications sector. Key Requirements: - Expertise in B2B sales: The ideal candidate should possess a profound understanding of B2B sales, particularly in the telecommunications industry. Experience in selling phone services to businesses is a significant advantage. - Proven Appointment Setting Skills: The primary responsibility will be to set appointments, so a history of successful appointment setting is a must. Ideal Skills and Expertise: - Excellent Communication Skills: Clear and concise communication is essential in this role. The candidate must be able to effectively convey the value...

...operations and financial accountability. As a freelance data entry specialist, I offer comprehensive PO data entry services to assist businesses in managing their procurement processes seamlessly. With a keen eye for detail and a commitment to accuracy, I ensure that all POs are recorded promptly and accurately, facilitating smoother transactions and inventory management. I propose to provide professional PO data entry services tailored to your specific business needs. Accurate entry of purchase order details into your chosen database or software essential information such as PO number, vendor details, item descriptions, quantities, prices, and delivery cross-checking PO information against correspond...

I'm in need of a skilled professional who can help me generate leads. Unfortunately, I missed providing some important details in the initial questions. - I'm open to both B2B and B2C leads, so I need someone who can handle both categories effectively. - The industry I target is quite broad, including but not limited to Technology, Healthcare, and Real Estate. Hence, I need a freelancer who is experienced in lead generation across various sectors. - Lastly, the leads should be provided in an Excel spreadsheet. This is crucial for my further processing and follow-up. Your previous experience in generating and categorizing quality leads across different industries will be a huge advantage. Proficiency in und...

- PRESENTATION - We need a small AR projecte for the web, that show two options of AR: plane detection and with marker-based tracking, models ans marker image are in url, that i will provide you. - GENERAL FEATURES - Timline 1 or 2 days - With webAR - Adapted to mobiles - It must be done without Unity! - The AR must work whether it is opened from an Android and Apple device - Need the source code - The URLs must be modifiable - PROJECTE SCREENS The projecte will only have 3 screens... - MAIN SCREEN See image "main " - Screen Elements - 1 button to open plane detection screen - 1 button to open marker-based screen - MARKER SCREEN S...

I'm looking for an SAP B1 expert to help me extract critical data for a migration project. Your main tasks will include: - Extracting data from SAP B1, including customer data, inventory data, sales data, purchase orders, and financial data such as journal entries. - Ensuring the data is extracted in Excel format for ease of handling and migration. The successful freelancer should have: - Extensive experience working with SAP B1 and extracting data from it. - Proven track record of successful data migration projects. - A strong understanding of how to handle financial data, especially journal entries, within SAP B1.

...an exciting project to develop and a co-working space in Jaipur that is tailored to the unique needs and preferences of local professionals and entrepreneurs. Through extensive market research, I've gathered valuable insights into what potential clients value in a work environment. Here's what I'm looking for in a freelancer to bring this vision to life: - A skilled interior designer with experience in autocad planning, sketchup and vray 3d design, 3d rendors , photoshop rendors, minimalist and ergonomic workspace layouts, who can incorporate light color schemes and natural elements, etc - A technology consultant who can implement a robust digital infras...

I'm looking to hire a skilled writer to create an engaging and imaginative fantasy story for elementary school children between the ages of 6-10. This story should be a combination of creativity, excitement, and educational value. Key requirements: - Target audience: Elementary school children (6-10 years old) - Theme: Fantasy - Illustrations: Black and white only Ideal skills and experience include: - Proven experience in writing for children's books, especially in the fantasy genre - Ability to create engaging and age-appropriate content - Familiarity with the educational aspects of writing for this age group - Experience working with illustrators and understanding of the visual storytelling n...

...are seeking talented and specialized professionals in UI/UX Design to join our team. We are looking for individuals who can bring innovative and effective solutions to the creation of interfaces that not only delight but also provide an exceptional user experience. Responsibilities: - User Research and Analysis: Deeply understand user needs and behaviors. - Interface Design: Create attractive and functional designs for mobile and web applications. - Prototyping and Wireframing: Develop clear and functional prototypes and wireframes. - Usability Testing: Conduct tests to ensure the effectiveness of interfaces. - Style Guide Development: Create coherent and effective style guides and design ...

...Panel Frontend + Backend + Database + File storage Customer will choose a vehicle and upload an ECU or Transmission file. In admin panel, that file will be downloadable and a admins uploads processed version of the file. There will be a credit system in the platform. Customer will buy credits with their credit / bank cards and the credits will be deposited. They will spend their credits by requesting file processes. Also, there will be a shop section in the platform. Customers will be able to buy already uploaded files by admin. Customers shall be able to view their expenses and deposits as a list and that table should be exportable to excel. There will be 3 information pages which cus...

I am looking for a skilled data entry specialist with advanced proficiency in excel. The project at hand is a one-time copy typing task. The task involves: - Entering a variety of data types into an excel spreadsheet (Text, Numbers, and Dates). - Creating a custom excel template with less than 10 columns. Ideal skills and experience for the job include: - Proficiency in using Excel, especially in data entry tasks. - Strong attention to detail to ensure all data is accurately entered. - Experience in creating custom excel templates is an added advantage. Please note, I will provide the document that needs to be copied and expect the resulting spreadsheet to match the in...

...search of a top-tier developer who's proficient in creating mixed reality CGI experiences specifically designed for mobile devices. The goal of this project is to develop a captivating advertisement that highlights and promotes our brand to a broad audience. Requirements: - Development: The advertisement should be engaging, interactive, and tailored for mobile devices. It should effectively utilize mixed reality technology to create a unique user experience. - Branding: The content of the advertisement should be aligned with our brand image and values. The key focus is on building brand awareness and increasing audience engagement. - Interactivity: The advertisement should incorporate simple interactions...

Hi Muhammad, we have a new project that entails making a new catalog with our GretaGrove branding. 1 UV Panel Sheet 2. PU Stone Details required: Product Colour name SKU Code Dimensions Material Avantages: UV Panel Sheet: -Protect from sun UV RAYS -Durable -Ease of maintenance PU Stone: Suitable for interior and exterior Water Resistant Aesthetic Value Durable Will provide a short introduction text for both product ranges and images shortly.

...the expertise of a well-versed structural engineer to conduct a comprehensive review. To provide a bit of context: - The design is in its detailed stage and ready for a granular assessment. - I want a thorough examination of the entirety - from foundation to roof. This includes but is not limited to footing, columns, walls, beams and slabs. A successful bidder will ideally possess the following skills and experience: - Significant experience in residential project and structural design. - Attention to detail for detecting potential weak spots or errors. - Knowledge in the latest safety standards and building codes. - Ability to provide creative, practical, ...

We have a list of products. We need to check everyday, if those products have strikethrough price appear on them. All the products that need to be checked are from the same website. The following are the steps:- a) Excel file containing Product url list of about 300 products, all from the same website b) We should be able to run a macro etc, which we need to do multiple times daily c) When we run the script, it should check if for all those 300 products, there is a MSRP pricing appearing on the website d) The products have many variations, so it should check for all the varitions e) It should create each variation entry into a seperate column and highlight that product as a variation f) If any variation...

...looking for a highly skilled technical content writer who can produce informative and engaging content on Artificial Intelligence, Cloud, Cybersecurity. The intended audience will be both developers and business professionals, requiring the content to be deep, high-quality and precise. Here's what you should bring to the table: - Clear understanding of Cloud, AI and Cybersecurity - Excellent writing skills, with the ability to translate complex information into easy to understand content - Experience in writing for a technical audience, particularly developers and business professionals - Ability to write in a technical yet engaging style to keep both developers and business...

Data Entry Project - I am looking for a freelancer who can assist me with typing work. - The project involves entering data into a spreadsheet or a database. - The ideal candidate should have excellent typing skills and attention to detail. - There is no specific software preference for data cleaning, so the freelancer can use Excel, Python, or any other tool they are comfortable with. - The dataset contains 100-500 records or entries. - The project requires accuracy and efficiency in data entry. - Experience in data analysis would be a plus, but not mandatory. - The freelancer should be able to complete the task within the specified timeframe. - Good communication skills and the ability to follow instructions ar...

want an excel expert for google excel sheet, who can make raw material data entry for purchase of raw material stock add and when someone uses it then particular raw material to be subtracted from that item two sheets one is for list of items & another is for entry

Laravel who can start immediately. Work with ftp only. Import excel work

Yesterday, OpenAI released the new module "ChatGPT 4.0". I want to create a video on how to automate and visualize Excel files using this new version. The thumbnail should include my face, the Excel logo, the OpenAI logo, and the text "Automate Excel with ChatGPT 4.0".

I am in need of a professional web scraper with Python expertise, who can scrape data from a website(with filter Options) and convert it into Excel format. Key Requirements: - Expertise in web scraping with Python, including dealing with website search filters. - Proficiency in data extraction and manipulation. - Experience in converting extracted data into Excel format. Please note that the specific website and the type of data to be extracted has not been provided as it was skipped by me. The project can be detailed further with the selected freelancer. If you have the skills and experience in this area, please do apply.

...looking for a talented freelancer to create a logo for the "FCA Jugend Förderverein e.V." The association was founded in 2012 and focuses on nurturing young talent in football. **Brief Overview:** - **Name:** FCA Jugend Förderverein e.V. - **Year Founded:** 2012 - **Colors:** Black and Orange - **Description:** The association is dedicated to promoting youth football development and providing opportunities for young players to grow and excel in the sport. **Design Requirements:** - The logo should reflect the essence of youth, growth, and football. - Incorporate elements that symbolize progress, teamwork, and dedication. - Use the colors black and orange prominently in the ...

...have a detailed list on an Excel sheet that I need converted into an organizational chart. The chart needs to include information like 'Grade', 'Nationality' and 'Occupation' and display them in a visually appealing format. Key Requirements: - Convert an Excel sheet which consists of approximately 140 line items into an organizational chart. - Display the following information in the chart: 'Grade', 'Nationality' and 'Occupation'. - Create visual lines connecting positions to indicate the reporting relationships. - Provide the final output in both PowerPoint and Visio formats. Customization: I am looking for a moderate level of customization in t...

I'm currently looking for a specialist in selling NFTs on the Ethereum network, specifically in the field of art. The NFTs are already created, so the focus will be on promoting and selling them. The ideal candidate should have: - Proven experience in successfully selling NFTs on the Ethereum blockchain - A strong understanding of the digital art market and a solid network of potential buyers - Excellent marketing and promotional skills - Strong communication skills to facilitate negotiations with potential buyers Key responsibilities include: - Developing and implementing effective marketing strategies to sell the existing NFT artwork - Engaging with potential buyers and promoting the value of the NFTs - ...

...started using a database program called Formula Coster on his Apple IIc to figure out how to correctly price our baked goods based on ingredient costs, labor costs, overhead, etc. The program also allows us to store the formulas and makeup instructions for all our products based on the dough batch and individual pieces from the dough. It's a simple program that we still use today, but are afraid it may not continue to work very long. Other programs exist, but are all cloud based and require subscriptions with features we do not need. I am seeking an adept database developer to either continue work on an in-progress database or commence anew based on existing requirements. This database is intended for e...

I'm seeking a skilled individual to assist me in creating a custom project cash flow spreadsheet. The primary functionalities I'm looking to incorporate in this spreadsheet are budget tracking, expense categorization, and cash flow projections. The spreadsheet will be primarily used for inputting income and expenses and should be updated on a monthly basis. Key requirements: - Design and development of a custom cash flow spreadsheet - Implement budget tracking, expense categorization, and cash flow projections - Ensure ease of use and understandability for monthly updates Ideal Skills: - Proficiency in spreadsheet software (e.g., Excel, Google Sheets) - Experience in creating budget trac...

I require a freelancer to assist with a one-time copy typing project. The task involves entering data from a single document into an Excel spreadsheet. Ideal Skills and Experience: - Proficient in copy typing - Proficient in Excel - Attention to detail and accuracy - Previous experience in similar projects is a plus.

The program must be compatible with Windows 10, which searches for data inserted from a CVS file, therefore which has the possibility of loading a CVS file (one or more files) which, through a search window, tells me whether a certain value (alphanumeric) is present in the CVS file. If you have uploaded more than one, please tell me which one it belongs to. I already have the initial screenshot to show when starting the software and the one of the search window that I will provide, upon acceptance I will also provide a flowchart that explains in detail.

...outlines the requirements for a supply chain software application designed to optimize inventory management, automate distribution to branches, and classify products based on demand. 2. Business Needs Reduce inventory carrying costs: By optimizing stock levels based on demand and product value (Pareto analysis), the software will minimize unnecessary inventory holding. Improve stock availability: Ensure branches have sufficient stock to meet customer demand, reducing stockouts and lost sales. Increase efficiency in distribution: Automate order generation and shipment processes to branches based on real-time demand data. Enhance data-driven decision making: Provide insights into product classifications (A, B, ...

...freelancer to assist in crafting compelling proposals for my translation services business. The goal is to create proposals that effectively communicate my services' value to potential clients and help secure new contracts. - Expertise in professional business writing - Experience in the translation industry preferred - Strong persuasive and marketing skills to highlight unique selling points - Ability to tailor proposals to various client needs and industries - Proficiency in creating well-structured, clear, and concise proposals - Familiarity with proposal submission processes and requirements The ideal candidate will have a proven track record of successful proposal writing and ...

ADMIN ASSISTANT Required - Bookings - Email and Messenger correspondence - Online Advertising on Facebook Marketplace and Gumtree - Search online information - Excel Spreadsheets - Bookkeeping - Office work Job is full time Monday to Friday Thankyou

I'm looking for a skilled PHP developer who can make alterations on my current website. The job involves updating and deleting specific buttons. Ideal skills for this position include: - PHP expertise - Frontend development experience - Proven track record of similar projects The work requirements consist of: Button Modification: - Update and Delete functionalities need to be adjusted to drive a smoother UX - Exact buttons cannot be disclosed publicly, those details will be shared privately with the selected candidate. Note: There's no addition of new functionalities or features required. In return for your work, I promise clear communication, prompt payment, and positive feedback for a job well done. I look for...

I'm in need of a Excel setup algo that can execute orders on Zerodha from excel file. I require the following features: - One click button: The system should be able to place and execute my selected orders from excel with one click button. - Customizable Order Parameters: I need to be able to set my own order parameters, including the stock, quantity, price, and other variables. The ideal freelancer for this project should have experience in: - Developing python algo application with excel. - Integrating with Zerodha API. - Implementing automated trading systems. - Creating user-friendly interfaces, with some level of custom design.

Dedicated and focused Project Management Specialist with over 6.5 years of experience excelling at prioritizing, completing multiple tasks simultaneously and following through to achieve project goals. Flexible, detail-oriented and adaptive team player with expertise in Project Management & Operation, stakeholder management, and process improvements. Project Details :- 1. Project Overview: Developed and maintained project planning and scheduling, budgets, resource plans and status reports 2. Risk Management: Conducted risk management activities such as identification, quantification, response planning and monitoring of risks 3. Stakeholder Management: Facilitated meetings with stakeholders to review progress against ...

...in crafting a trust deed aimed at protecting my assets, specifically my occupied home. This trust deed has a single beneficiary. - Primary Objective: The objective is to safeguard my home from any potential risks or liabilities. This is intended to maintain my property's status and value and decrease my exposure to future liabilities. - Beneficiary: The trust deed will only have a single beneficiary. The desired candidate should have an understanding of how to properly structure a trust deed to ensure the beneficiary's benefits are secure and legally sound upon my passing. - Asset Details: My primary residence is the asset I wish to protect through this trust deed arrangement...

As a client seeking to improve my understanding of excel, I would like a skilled instructor to guide me through the basics of formulas and functions, data analysis and reporting, as well as formatting and conditional formatting in Excel. Although I don't have a specific completion time, expediency is appreciated. Skills and experiences that would be ideal for this job: - Advanced Knowledge of Excel - Excellent Teaching Skills - Flexibility to cater to learning pace No preference was selected for the type of learning medium, so offering a blend of online videos, live training sessions, and written instructions could be beneficial to cover all bases.

We are in need of a installation video and some photos for my product RV roof vent fan The video should be casual in nature and not overly promotional. We will send you the product and no need to return it after it's installed.

We are in need of a installation video and some photos for my product RV roof vent fan The video should be casual in nature and not overly promotional. We will send you the product and no need to return it after it's installed.

I am looking for a proficient fitness trainer who's also knowledgeable in creating and managing a high-protein diet plan. Objectives: In our sessions, our main focus will be on: - Muscle building and strength enhancement. Skills and expertise: I will highly value: - Experience in helping others increase muscle mass and strength. - Skills in creating high-protein diet plans to accelerate muscle building. Experience level: Potential trainers should note: - Although I have some previous experience in exercising and muscle building, it's limited hence open to all the professional guidance I can get.

ADMIN ASSISTANT Required - Bookings - Email and Messenger correspondence - Online Advertising on Facebook Marketplace and Gumtree - Search online information - Excel Spreadsheets - Bookkeeping - Office work Job is full time Monday to Friday Thankyou

I'm in need of a Full-Stack Developer who is well-versed in ReactJS, NodeJS, CSS, and Python. The project will require both front-end and back-end development. In detailed, we're developing a web workflow application and I'm looking for an experienced developer for a task of about 2-3 weeks to create an interactive workflow with React front-end and Python backend (see the 3 attachments to this post with the main job description is in the file MTQ - Upwork - Interactive Front Panel - and the other attachments are supporting documents). SUMMARY: Tabbed ReactJS forms with a Python backend that can interact with each other. The front-end can have a few input fields and a few inter...

questions added to excel

I am looking to establish a reliable and professional ironing and pressing service tailored to busy professionals. Key Requirements: - The primary service offered is ironing and pressing of clothes. - I am specifically targeting busy professionals who value quality and convenience. - I would like the scheduling of pickups and deliveries to take place through phone calls. Ideal Skills and Experience: - Experience in providing high-quality ironing and pressing services. - Understanding of customer needs, especially of busy professionals. - Ability to manage a service-based business with phone call scheduling.