How to merge two excel sheets based on one column vlookup punët

...require an expert in Excel to help me with a statistical analysis of my sales data. The key tasks for this project are: - Conducting statistical analysis: I need you to run a detailed statistical analysis on my sales data. This will involve using advanced Excel functions to analyze variables such as sales trends, forecasts, and correlations. The ideal candidate for this project should have: - Proficiency in Excel: The chosen freelancer should have a deep understanding of Excel and be skilled in using advanced functions. - Statistical Analysis Expertise: Experience in statistical analysis is crucial, as you will be required to interpret the data and provide insights. - Attention to Detail: The work involves handlin...

I'm in need of a talented game developer to create a mobile game for both iOS and Android, in the grinding genre. I will provide map converters and all necessary assets for the game. Key Features: - Multiplayer Functionality: The game should have the capability for players to interact with each other in-game. - Leaderboards: Implement a system for players to compare their achievements and progress. - In-app Purchases: Include a functioning in-game store where players can purchase virtual goods. As the project is mainly about implementing the provided mechanics, I'm looking for someone with experience in online game development, particularly in the mobile sector. In addition, knowledge of grinding game mechanics will be helpful. An ideal candidate would hav...

The most emblematic activities to do. The popup login action will be added to the header and from the home page button. Next buttons will also be hidden in lessons.

I need to improve the existing features of an Excel macro, focusing on enhancing the user interface and experience. Key points: - The primary goal is to make the macro more user-friendly, interactive, and provide better feedback to users. Ideal skills: - Advanced Excel Skills - VBA and Macro Programming - Strong UI/UX design capabilities - User Feedback Integration Please bid if you have experience in enhancing Excel macros in a user-friendly manner and can improve the UI/UX by adding interactivity and feedback. I have a macro working fine. We need 3 improvements: 1- Label photos as A, B and C / 1, 2 and 3 then macro relabel photos per photo matrix 2- Instead to use “SN” in the folder name I want to use &ldquo...

...Articulate Storyline expert to create an exciting, interactive game-based learning module targeted at adults. Requirements: - The module should have a moderate level of interactivity, including quizzes and drag-and-drop elements - The content must be engaging and challenging for adult learners, it should be both informative and entertaining - Attention to detail is crucial, the module should flow well and be free from technical errors - You are encouraged to bring creativity and originality to the project, it should not be a standard, uninspired e-learning module Ideal Skills: - Expertise in Articulate Storyline is paramount - Experience in developing game-based learning modules is a major plus - Understanding of adult learning pri...

I'm seeking a savvy developer to create a 1D barcode (UPC, EAN) inventory management system. This should then be integrated with an existing product management system. Key requirements: - Design and develop a user-friendly barcode inventory control system - Experience with 1D barcodes, preferably UPC and EAN - Capability to integrate with existing product management software The main users of this system will be store staff members. Therefore, it should be easy to navigate, and seamless in functionality to support a fast-paced retail environment. Expected expertise: - Proven experience in building similar inventory management systems - Proficiency in working with 1D barcode technology - Expertise in software integration - Solid understanding of user ...

...automate various tasks in Excel. This includes, but is not limited to, data entry, formulas, and calculations. Key responsibilities: - Automating data entry processes within Excel - Implementing advanced formulas and calculations to streamline calculations - Generating reports and carrying out data analysis using Excel - Ensuring the accuracy and integrity of automated processes Ideal skills and experience: - Proven experience in automating tasks in Excel - Advanced knowledge of Excel functions and formulas - Ability to understand complex data sets and create accurate reports In your application, I'd like to see: - Examples of similar projects you've worked on - Details of your experience with Excel...

I am seeking an expert in data entry, particularly in the tasks of document conversion, data processing, and data verification. This role necessitat...of confidential and sensitive information, hence, a demonstrated respect and understanding for data privacy is paramount. Key Responsibilities: • Document conversion • Data processing • Data verification Required Skills and Experience: • Proficient with MS Excel • Demonstrated experience in similar roles handling sensitive data • Strong attention to detail • Respect for privacy and confidentiality Note: Familiarity and experience with utilizing formulas and pivot tables within Excel are highly desirable, given the nature of tasks to be performed. Integrity, diligence, and me...

I need assistance with copying & pasting data from spreadsheets. The dataset is less than 1,000 entries. Ideal skills and experience for this job: - Experience with data entry, especially from spreadsheets - Attention to detail - Proficiency in Excel - Ability to meet deadlines It's a straightforward task. The goal is to ensure the data is accurately copied and pasted.

I need an experienced Excel programmer to automate repetitive tasks and create custom VBA macros for my project. This assignment requires basic level tasks, so extensive experience in complex macros isn't necessary. Here is what I expect: - Automation of several repetitive tasks to streamline workflow and increase productivity - Creation of custom VBA macros from scratch Ideal Candidate: - Extensive experience with Excel automation and VBA macros - Ability to comprehend and successfully complete basic level assignments - High attention to detail and accuracy Please include your Excel automation and VBA macros experiences in your application. I look forward to working with you on this project.

...skilled freelancer to create a comprehensive lead generation and auto-boarding system using System.io. Key Responsibilities: - Developed using for B2B lead generation, with the primary goal of increasing lead generation - Implement effective email marketing strategies within the system - Incorporate conversion optimization tactics to maximize lead conversion Ideal Candidate: - Intermediate level expertise in using - Extensive experience in lead generation, ideally within a B2B context - Proven track record in successful email marketing campaigns - Strong understanding of conversion rate optimization The project will require a highly organized individual with a keen eye for detail and the ability to implement a strategic and data-driven approach to lead ...

I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample

We want to extract members from one Facebook group which contains about 24.000 members. We don´t know if this is possible or not. We want to create a group and invite all these members to them.

This is for my College final project, I need to develop a simulation of AI based threat detection.

Ju lutemi Regjistrohuni ose Identifikohuni për të parë të dhënat.

Functionalities of Chrome extension : 1: scan any buttons fields used computer vision or openai vision or Google gimini to recognize fields or buttons 2: creator record macro auctions in same time record/uploading voice and notes 3:export files then shared the files with others that have same chorme extension Output: macro working without in others that have same extension 4: deployment on marketplace

...professional designer to create a 24-page A5 booklet for my estate agency. I want the design to be traditional and elegant, as our target is to attract new potential clients. Key Requirements: - The booklet should be 24-pages long, a5 sized (6 a4 sheets folded in half to A5 size). - The design style should be traditional and elegant. Content: - I'm keen to include information on local property values in the booklet. This is crucial for potential clients who are interested in the real-estate market in our locality. Skills and Experience: - I expect the designer to have experience in creating similarly styled elegant and traditional designs. - A good understanding of the real-estate market or experience in designing for est...

Remove background and merge in one image. Product type: coins/ medals

I require a capable developer to create a new Python module from Wazuh server using C programming. This module should retain the following functionalities from the original: - Agent registration - Remote configuration - Log receiving A deep understanding of TLS and SHA technologies is a must.

...seeking an experienced Excel wizard capable of making my inventory report more dynamic and adaptable. Here's what I need: - Total Calculations: The report doesn't currently update the total inventory count and monetary value when I adjust the count of individual items. I require this to be automated so the totals are accurately recalculated whenever an inventory count changes. - Regular Updates: Going forward, I will be regularly updating inventory counts on a weekly basis. I would appreciate if the system is simplistic and user-friendly for regular updates. Ideal Freelancer Skills: - Advanced knowledge of Excel functionalities - Experience on inventory management systems - Meticulous attention to detail - Ability to create ...

I'm looking for a skilled engineer who can design a self-supported steel chimney for a metal manufacturing plant. This chimney will be integral to industrial emissions control. Tasks Include: - Tailoring the design to accommodate the specific needs of a metal-manufacturing environment. - Incorporating robust safety features and compliances for high-temperature metal emissions. Ideal skills: - Structural Engineering - Industrial Design - Knowledge of industrial emissions standards - Experience with metal manufacturing processes.

I'm seeking an experienced CAD jewelry designer for custom-made jewelry pieces. Key tasks include: * CAD designs for a three different types of jewelry: rings, necklaces, and bracelets. * All designs will need to incorporate a mixture of materials such as gold, silver, and gemstones. The ideal candidate would have: * Proficiency in CAD software specifically for jewelry design. * Familiarity in using diverse materials such as gold, silver, and gemstones. * Experience in creating varied forms of jewelry like rings, necklaces, and bracelets. Your portfolio displaying your previous work in CAD jewelry design will be highly favored in the selection process.

Project Title: AI Image Processing for User Face Image with Clothing Overlay I am looking for a freelancer who can utilize AI technology and image processing to create a single image that combines a user's face image with clothing overlay. The specific requirements for this project are as follows: AI Technology: - The freelancer should have expertise in image processing techniques to achieve the desired result. API Preferences: - There are no specific API preferences, and the freelancer can use their discretion in selecting the most suitable API for the task. Final Output: - The final output should be a single image that contains the user's face image with clothing overlay. - The clothing overlay should include a t-shirt from a second image and pants from a thir...

...skilled developer to create a web-based basic arithmetic calculator. Primary Functions: - The calculator should perform basic arithmetic operations such as addition, subtraction, multiplication, and division. Key Features: - The calculator should have a clean and user-friendly interface. - A history feature is optional, if you can integrate it seamlessly without compromising the simplicity of the calculator, that would be a plus. Ideal Skills: - Proficient in web development, particularly in developing interactive and user-friendly interfaces. - Prior experience in building calculators or similar tools is a big plus. - Strong understanding of basic arithmetic operations and their implementation in code. This is a great opportunity to showcase your web developm...

...involves segmenting primary school level maths questions based on the specific skills required to answer them correctly. The task will be to review 50 past papers - containing approx 50 questions each. For each question, I need someone to: - cut & paste an image of the question into a Google slides / Powerpoint document - 1 question (or sub-question if it requires a different skill per page - 1 document for each paper - name the skill(s) that are required to answer each question - as the title for each page - create a new line in a Google Sheets / Excel document with the following information: - skill required (copied from title of Google Slides document) - page number of Google Slides document that the question ...

...team of live streamers based in Saudi Arabia. The focus of the live streams will be on product reviews and promotions. I have specific products and brands that I want the team to promote during the live streams. Ideal candidates should: - Be based in Saudi Arabia and have a good understanding of the local TikTok community - Have a passion for product reviews and promotions - Have a strong presence on TikTok with a good number of followers - Be able to effectively engage with the audience and drive sales - Be creative, dynamic, and able to think on their feet Your primary responsibility will be to host live streams, review and promote the products I provide, and engage with the audience in a way that maximizes sales and br...

I'm looking for a Python developer to assist me in creating a web scraper that can extract specific text content from a website on a weekly basis. The scraped data should be efficiently saved to a CSV or Excel file for easy review. Capable of being plugged to a distribution app. Key Requirements: - Develop a Python-based web scraper that targets a website to extract text data - The scraper should be designed to run on a weekly schedule - Ensure that the code is concise and easy to understand for potential future modifications - Store the scraped data in a CSV or Excel file format Skills and Experience: - Proficiency in Python programming - Experience with web scraping libraries such as BeautifulSoup or Scr...

I'm looking for a proficient Excel professional to develop a multi-country income tax calculator. This tool will primarily serve individual taxpayers, and potentially other user groups. Key Requirements: The calculator should support income tax calculations for multiple countries. This requires a deep understanding of tax laws and calculations in each country. - The tool should be user-friendly and intuitive, catering to users with different levels of tax knowledge. - It should be well-structured, with separate sections for each country to avoid any confusion for the end-users. Ideal Skills and Experience: - Advanced Excel proficiency, with experience in creating complex calculators or financial models in Excel. - In-depth knowledge of...

I need an expert to develop a macro tailored to automating report production tasks in Microsoft Excel. The main purpose of this project is to streamline the process of regular report production and increase overall efficiency. Ideal skills and experience include: - Proficient in Microsoft Excel - Experience in macro development to automate tasks - Knowledge in automating report production Your role will involve designing and implementing a suitable macro for regular report production in Excel. I'm looking for someone who can provide a timely and efficient solution.

I'm seeking a skilled web designer to improve an existing visually engaging, informational website for a general audience (mostly big companies and legal companies worldwide) It will primarily host text and image content. Ideal candidate should: - Have a rich portfolio of visually diverse websites - Have strong expertise in designing image-focused sites - Understand best practices to cater the design for a general public - Be detail oriented, and able to optimize images for quick loading times and responsive design. The existing website that i want to improve is

I'm in need of a skilled automation specialist to help me streamline and optimize a multi-step process that involves audio analysis and documentation. Key Responsibilities: - Develop a solution (on ) that initiates from an audio file recording and proceeds to: - Audio-to-text conversion using Google Cloud Speech-to-Text - Running the transcript through ChatGPT for analysis - Summarizing the outcome in Google Docs - Maintaining a daily list of patients' names in a Google Sheet Key Objectives: - The primary goal of this automation is to enhance productivity, allowing staff to focus on more intricate tasks. - All stages of this process need to be fully automated. Additional Details: - The daily list o...

I'm looking for a sales representative based in the MENA Region to help promote our Active Pharmaceutical Ingredient (API) business. Key Responsibilities: - Focusing on countries including Saudi Arabia, UAE, Egypt, Morocco, Algeria - Prioritizing efforts in Saudi Arabia, UAE, Egypt, and Morocco - Assisting in increasing sales and market presence - Establishment of new partnerships - Promotion to local B2B clients - Support in order procurement Ideal Candidate: - Proven experience in pharmaceutical sales - Deep understanding of the MENA region - Strong sales and negotiation skills - Existing network within the pharmaceutical industry - Excellent communication and interpersonal skills

...exhibitions. Key Requirements: - Proficiency in running location-based Google Ads: You should have a proven track record of running successful campaigns at pharmaceutical trade shows, industry-specific exhibitions, and across various countries. - Understanding of the pharmaceutical industry: Knowledge of the industry is a must, especially in relation to marketing APIs. - Worldwide targeting expertise: You will be tasked with targeting countries like the United States, China, Germany, MENA regions (Gulf Cooperation Council (GCC) and North Africa) and Latam regions (Mexico, Brazil, and Argentina). Your role will primarily involve: - Strategizing and executing Google Ads campaigns at specific exhibitions. - Tailoring campaigns to different countries and regions whi...

I'm seeking a skilled virtual assistant with proven communication abilities, to work specifically in US timezone. Your main duties will include: - Bidding on projects: You will need to represent our brand professionally and persuasively when bidding on projects. - Communicating with leads: You'll be responsible for using various messaging platforms to engage with potential clients and leads. Ideal candidates should excel in written communication and have a knack for sales. Proficiency in project management tools is a plus. Our preferred mode of communication with leads is through messaging platforms.

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.

...webmaster to manage and maintain our services-based e-commerce website. The ideal candidate will have a robust understanding of WordPress, e-commerce functionalities, and website maintenance to ensure optimal performance and a seamless user experience. Key Responsibilities: Website Maintenance: Conduct regular checks to ensure the website's smooth operation. Identify, troubleshoot, and resolve technical issues promptly. Perform routine backups and security updates to protect the site from vulnerabilities. Content Updates: Update site content, including text, images, and multimedia, to keep it fresh and engaging. Collaborate with content creators to ensure accuracy and relevance. Implement SEO best practices to enhance site...

Preparing financial statements for the year 2023 typically involves gathering data from various sources such as income statements, balance sheets, and cash flow statements. This data is then organized, analyzed, and compiled into the appropriate financial statement formats following accounting principles and standards. Additionally, any necessary adjustments or reconciliations are made to ensure accuracy and compliance with regulatory requirements.

I'm in need of a professional with expertise in HubSpot and its integration with our app Primary Objectives: - Increase customer engagement - Streamline our onboarding process ...expertise in HubSpot and its integration with our app Primary Objectives: - Increase customer engagement - Streamline our onboarding process - Improve our lead generation process Key Tasks: - Develop and implement a strategy for CRM integration between HubSpot and Sheets - Optimise the use of HubSpot features with Sheets integration The ideal person for this task should have proven experience with HubSpot, excellent understanding of CRM systems, and an ability to streamline processes for optimal efficiency. Capability to troubleshoot and resolve any issues that may arise duri...

I need help with data entry and formatting for a Google Sheet. The data is to be sourced from ONLY 1 Website. Key Tasks: - Copy-pasting text information and images or screenshots from Website 1 into a Google Sheet. - Formatting the data in the Google Sheet with columns and tables. Ideal Skills: - Proficiency in data entry, specifically with Google Sheets. - Strong attention to detail to ensure accuracy and completeness of the data. - Ability to organize data efficiently using columns and tables along with images etc for capturing the User flow in a tree form . Example the website has Question 1 and N number of responses. Based on the responses there are different questions based on the responses. Need to capture t...

...Form document (tables filling 2 pages) that I'd like converted into a webpage form that users can interact with. The form will be used to enter essential information to properties by our data entry operators. This will be one (1) html page only, no backend development necessary (php receiving the form optional, see below). „Nice Admin“-Template must be used: Project Requirements: - Convert Microsoft Word Document (2 pages) to Web Form: Transform the content and layout of the Word document into a web-based form. - Responsive Design: Ensure the form is fully responsive and looks great on all devices (desktop, tablet, and mobile). - Form Fields: Create all necessary form fields as outlined in the Word document, including text

Need 2 hours tutoring. I have a wix website and I want to understand how to add and remove blogs on the wix website. please let me know the price for 2 hours tutoring.

The project consists of an AI-based booking platform that receives booking orders from various text sources. The text does not have a predefined format. The AI analyzes the text to generate the corresponding booking order in a predefined format, enabling integration with a small ERP software. Input and output data must be defined and calling functions created in C# if required. The AI is desired to be working on a private local server running Microsoft Windows Server.

...neatly exported to a Google Sheet. Key requirements: - The crawler should not be intrusive to the host website. - I want the crawler to crawl current and expired ads based on links present in the site map, as historic data is also of importance to me - You should be able to provide a way for me to run this crawler myself at any time - ideally on a monthly basis. I haven't yet decided on the precise fields to be extracted. I'm looking for someone with the skills to recommend suitable fields that could be beneficial for my project. It's important that the extracted data is organized and easily readable once exported to Google Sheets. Ideal freelancer should have previous...

I need help with my Microsoft Excel project! Specifically, I require assistance with the following: - **Formulas and Functions:** - Basic arithmetic operations. I don't need anything too complex, just fundamental formula structures. - **Automation:** - No macros for repetitive tasks are required, but I need guidance on setting up conditional formatting rules within the document. I'm looking for a Freelancer who is experienced in Excel and is comfortable with basic arithmetic operations and conditional formatting. You should be able to provide clear, concise, and easy-to-follow guidance. A strong attention to detail and excellent communication skills are a must. If you're proficient in these areas, I'd love to ...

I'm seeking a skilled developer to integrate a pixel into my WordPress website that collects the names, emails, and phone numbers of leads in real-time as soon as they visit a specific page. The collected data should be simultaneously sent to GoHighLevel (GHL) CRM for automated text and phone call follow-ups, as well as to an Excel sheet for manual review and further action. Key requirements: - Pixel Integration: Develop and implement a pixel solution that captures lead data. - Real-Time Collection: Ensure the system collects data instantly when a lead lands on the specified page. - GoHighLevel (GHL) Integration: Connect the system to GHL for automated text and phone call follow-ups. - Excel Integration: Enable the system to sen...

We need a one-page landing page for an IT-product created, if this works out well, we need help to create more landing pages. 1.) Make a design proposal of a one-page landing page site 2.) Create the design (with SEO in mind) in Wordpress with Divi or Maxiblocks (preferred), preferably populate with suitable free (usage rights) pictures. 3.) Possibly some minor design adjustment after we add our own data to the page. We want a static price for this. Thank you!

I need a freelancer to help me gather phone numbers from clothing stores in County . You'll be provided with the location and shops to focus on. Key Responsibilities: - Utilize street view to identify shops - Collecting phone numbers of all such shops - Organize and input these numbers into an Excel spreadsheet Ideal Skills: - Proficient in using street view and other location tools - Detail-oriented and capable of data entry - Comfortable using WhatsApp for communication This is a straightforward project, but attention to detail is crucial. Feel free to reach out if you have any questions.

I'm looking for a dedicated chatter based in India who can proficiently communicate in English. Ideal skills and experience for this job include: - Fluency in English to provide effective chat - Previous experience in chat service roles - Comfortable with using messaging platforms for interactions - Basic understanding of chat service principles - Empathetic and patient communication style - Preferably based in India for time zone compatibility.

I am seeking a proficient and reliable safety advisor for a substantial lineup of Music Concerts, Spo...Excellent crisis and crowd control management skills. - Relevant qualifications in safety and emergency management NEBOSH ICG as minimum - excellent communication management - experience in generating reports - advanced Microsoft skills particularly in (words, excel and power point) Your role will be pivotal in ensuring our events are safe, enjoyable and error-free. The ideal candidate will anticipate issues before they arise and resolve them swiftly when they do. Your proficiency in maintaining safety at massive events will be the key to a long-term partnership. Location: KSA Period: 3 months (extendable) Commencing approx: Aug-Sep 2024 Expenses covered: Transportatio...