How to compare two columns in excel using vlookup jobs
...**Project Description:** I need a skilled freelancer to perform **web scraping** for a specific project. Here are the details: 1. Scrape data from [website name: stats perform/URL: ]. 2. Extract the following information: - [Specify the data fields you need, e.g., Seasons, Matchday, Results, Match Summary, Opta Points, Match Details, Venue, Attendance, Referee, date, Goal Assist, Cards, Cross ,Foul won, Foul conceded, Goal/Own Goal, Interception ,Offside, Pass, Penalty (Won, Conceded and Taken), Shot, Shot on target, Shot off target, Tackle, Save, Penalty Save] 3. The data should be delivered in [desired format, Excel, CSV]. 4. Ensure the script is reusable for future updates
I'm seeking an Excel expert to analyze customer data and create advanced charts to compare various customer segments. The ideal candidate will have a strong background in data analysis and modeling, with a deep understanding of advanced charting techniques. Key Requirements: - Proficiency in Advanced Excel, particularly with advanced charting, data analysis, and modeling. - Ability to transform raw customer data into insightful, easy-to-understand visual representations. - Experience in identifying trends and patterns within customer data. If you have the necessary skills and experience, please get in touch so we can discuss the project in more detail. Thank you.
I need assistance updating 10 to 50 Word documents based on information from an Excel sheet. Ideal skills and experience for the job includes: - Proficient in Microsoft Word - Good attention to detail - Ability to understand and follow instructions from an Excel sheet. Please note that the specific updates required are currently unspecified.
...and Transaction Analysis Objective: To analyze and correlate inter-account transfers across multiple bank accounts, match transactions that flow from one account to another, and reconcile these with descriptions of the source, origin, and purpose of funds provided in previous submissions. Scope of Work: Data Consolidation: Compile transaction data from all provided bank accounts (FNB, Bidvest, etc.) into a unified format for analysis. Inter-Account Matching: Identify and correlate transfers between accounts (e.g., Account A to Account B) by matching amounts, dates, and any available references. Flag any unmatched or ambiguous transactions for further review. Transaction Categorization: Use the previously provided descriptions (shared with my accountant) ...
I'm in need of an Excel expert to assist with various financial tasks. This includes: - Creating budget spreadsheets - Analyzing staffing costs - Generating financial reports I will also require some custom Excel formulas to be created. The level of automation needed is basic, primarily using standard formulas. Ideal candidates for this project should have: - Extensive experience with Excel - Proficiency in creating budget spreadsheets and analyzing financial data - Ability to create custom Excel formulas - Basic understanding of automation using Excel formulas
I have a 30-page document containing text and numbers that needs to be converted into a basic Excel table. The table should be structured with rows and columns, following predefined headers from the document itself. Ideal Skills: - Proficient in Excel - Experienced in OCR technology - Attention to detail - Ability to follow specific instructions Please note, the document will likely present some challenges for OCR due to its complexity. Therefore, a freelancer with strong problem-solving skills and patience will be highly valued.
Description: I am looking for an experienced web scraper to extract product reviews and general product data for Alpine Baby Muffy and Kids Muffy hearing protection earmuffs. Project Requirements: 1. Data Extraction: Target Websites: E-commerce platforms (Amazon, eBay, Walmart, official retailers, review sites, etc.) Primary Focus: Extracting and categorizing customer reviews into: Positive remarks (what customers like) Negative remarks (what customers dislike) Additional Data Points: Product name Price Availability (in stock/out of stock) Retailer name & website URL Product specifications Customer ratings (e.g., average rating, number of reviews) 2. Data Processing & Output: Output the review remarks in a structured format (CSV, Excel, or JSON) Categ...
I'm in need of a proficient data entry specialist. The project requires entering specific data fields into an Excel spreadsheet. You'll be dealing with: - Data Fields: Name, Address, Email Your tasks will include: - Data Entry: Inputting the specified data fields into Microsoft Excel - Data Cleaning: Ensuring the data is accurate and free from errors - Data Validation: Adhering to unique data validation rules as instructed Ideal skills and experience for the job: - Proficiency in Microsoft Excel - Experience in data entry and data cleaning - Attention to detail for data accuracy - Ability to meet deadlines - Familiarity with data validation rules Please be prepared to adhere to: - Expected Format: D...
I need a freelancer to assist me with collecting quantitative data from a provided list. Key Requirements: - Proficient in data collection techniques - Able to work with an Excel/CSV file - Experience with handling quantitative data Your task will primarily involve extracting information from my list and compiling the data into a coherent format. Experience with data analysis tools and techniques can be beneficial. Please note, attention to detail is crucial for this project.
I'm looking for a professional to apply on my behalf to various job platforms like Indeed, LinkedIn and Glassdoor. Apply For The following 1. software developer 2. desktop support analyst 3. programmer analyst Ideal skills for the job: - The roles should be mid level or senior-level with a salary of 70K or more - I'm only interested in jobs located in Orange County or LA County in California. - You will need to send my resume to each application. - I expect a comprehensive excel list of all applications made. Please note that the applications should be tailored to each platform and role, showcasing my relevant skills and experiences.
...this request: Due to time constraints, I might choose more than one resource on React based Dashboard and assign $50 initial, whoever do quick turnaround I will give them full project. I'm looking for a skilled React developer to create a dashboard for visualizing user analytics in a comprehensive and engaging way. Key Requirements: - Use of React framework to build a responsive and interactive dashboard, Visualization of data through charts and graphs. - Select, upload excel in UI and work all Excel Formulas like Lookups, Aggregates, Database Tables, to display tabular and tiles, widgets - Integration of user demographic and usage pattern data into the dashboard. Requirement is in Two pages, I will share w...
...*************************************** Project description : This is an intensive, manual work project that will take at least 4 hours of dedicated Excel skills Please proceed with reading further, only if you are willing to work hard and devote time to complete the task correctly. It CANNOT be automated or run via a script. It CANNOT be outsourced via code. It cannot be "done using AI" . Please do not waste your valuable time trying to do either. The task: There are Some handwritten notes with approximately 1000 records. These are student data for a school in India. Your task is to neatly organise and write the data into an Excel worksheet. You will create 1 separate worksheet for each class, e.g., : 1. Nurse...
I'm looking for a freelancer who can help me scrape text content from a specific website and deliver it in an Excel spreadsheet. Ideal Skills and Experience: - Proficiency in web scraping tools and techniques - Experience with data organization in Excel - Attention to detail to ensure all relevant text content is captured Please note, the specific sections of the website to be scraped have not yet been determined, so flexibility and adaptability will be key.
I'm looking for a professional to create detailed RCC structure layout plans for a small community hall. The hall will primarily be used for community events. Key Requirements: - Comprehensive layout plans including the placement of columns and beams, foundation details, and reinforcement details. - Design aimed for a small hall, with dimensions up to 500 sqm. Ideal Skills and Experience: - Proficient in structural design and engineering. - Prior experience designing for community facilities is a plus. - Strong understanding of RCC structures. - Excellent attention to detail and ability to create comprehensive layout plans.
I am a data analyst in need of assistance with creating a sales report in MS Excel. Ideal skills for this project: - Expertise in MS Excel - Strong data analysis skills - Experience in sales report creation Looking forward to your bids.
I'm in need of assistance with document creation and editing in Microsoft Word, specifically for creating and editing reports. The ideal candidate should have a strong proficiency in Microsoft Office applications, particularly Word, Excel, and PowerPoint. Key Responsibilities: - Assist in the creation and editing of reports - Incorporate images and tables into the reports Ideal Skills: - Proficiency in Microsoft Word for document creation and editing - Experience in creating and editing reports - Ability to incorporate images and tables into documents - Strong attention to detail - Excellent communication skills
...betting market, on the betting sites I am attaching in an Excel sheet. The layout should be similar to that of , see picture attached. I have 647€ in my freelancer account, that is my maximum budget for this project. I have a Linux VPS server subscription, the system should run on that server. Key Features: - Web-based platform: The system should be accessible and fully functional on the web. - Comprehensive sports coverage: The system must cover every sport, not just football, basketball, and tennis. - All betting markets: The system should be able to identify opportunities in every betting market, including match result, over/under, and handicap. Ideal Skills and Experience: - Proficient in web development, ideally with experien...
...BI expert who can build a sophisticated dashboard for me. The primary goals of this project are to visualize data related to Sales opportunities, Production/Project schedules, and Finance. Key Responsibilities: - Data Visualization: Create clear, insightful visual representations of complex data sets. - Reporting and Dashboards: Develop and deliver comprehensive reports and interactive dashboards. Data Sources: The dashboard will need to pull data from a variety of sources, including: - Excel files - Tenica - HubSpot - BCI - PDF - CRM Database - Workflow - POAP/Project on a page/XL Integration Requirements: The following data sources need to be integrated into the Power BI dashboard: - Excel files - HubSpot - CRM Database Skills and Experien...
I need a 600-page pdf written in Microsoft Excel for record-keeping, specifically for inventory data. The document must include: - Item names and quantities No formulas or complex Excel functions are required. This project is ideal for freelancers with excellent attention to detail and experience in data entry and inventory management.
I'm in need of a reliable and efficient data scraper who can pull order details from my Aliexpress account into an Excel file. The scraper should allow me to manually set a date range for the data I want to extract. -Data Requirements: I will provide a template for the data. - Frequency of Task: I would like the scraper to be user-friendly enough so that I can set a start and end date for future data scraping tasks each time I run the scrapper. Ideal skills for this project include experience with web scraping, familiarity with Aliexpress, and proficiency in Excel. A good understanding of data handling and the ability to create a user-friendly interface will be an added advantage. I have attached below a sample of output f...
We're seeking an experienced Web Developer for two exciting website development projects: Project 1: Subscription-Based Video Editing Platform Development of a service subscription platform Implementation of a credit purchase/payment system User account management Secure payment gateway integration Dashboard for service tracking Project 2: Event Management Website Online booking system development Event calendar integration Telegram API integration for notifications and updates Payment processing capabilities User-friendly booking interface Administrative dashboard Automated Telegram notifications for bookings and updates Required Skills: Strong experience with full-stack development Payment gateway integration expertise Database management UI/UX best practices Security imp...
My Excel sheet requires some urgent formatting adjustments to properly calculate and display the gross profit (GP) of items. Key Issues: - Formatting problems predominantly in the cells and tables Necessary Skills: - Advanced Excel expertise - Experience with data validation and conditional formatting - Attention to detail to ensure accurate GP calculations Your role will be to troubleshoot and rectify the formatting issues to ensure the sheet operates correctly and efficiently. Your expertise will allow for the implementation of necessary data validation and conditional formatting to improve the functionality of the sheet.
...for a C# developer to create a Power BI optimization plugin. The plugin should do the following: - Detect all open Power BI files - Identify tables and measures within those files - Create optimized DAX code for the selected measure - Generate optimized SQL queries for tables sourced from SQL databases - Develop optimized M queries for Excel files and other file types The plugin should support SQL databases, Excel files, and CSV files for optimization. It should also be able to remove all unused columns in the selected table. Ideal candidates for this project should have: - Extensive experience with C# development - Deep understanding of Power BI - Proficient in DAX, SQL, and M query languages - Experience working with various file ty...
I'm looking for a talented meme creator who can help me edit a funny photo of me. The meme needs to be using my face and the more outrageous it is, the better. I'm thinking of features like a big butt, silly facial expressions, and some bold and outrageous editing. Skills and Experience Ideal: - Proficient in meme creation and photo editing - Creative and has a good sense of humor - Able to create exaggerated features in a funny way
I need a straightforward travel calculator focused solely on air travel. This tool should be built in Excel and utilize a simple user form with concealed tables that house the necessary data sets. Key Features: - The calculator should handle only air travel. - It should factor in flight distance and also calculate frequent flyer points based on the journey. - The user input form needs to encompass departure and arrival locations, class of service, and booking class. Ideal Skills: - Proficiency in Excel, particularly in creating interactive user forms and concealed data tables. - Understanding of air travel metrics and frequent flyer point systems. - Ability to create a user-friendly, simple yet effective travel calculator.
Hi, I am faving an issue in my iOS App. There is also AR/VR, so developer must have good skills in Mobile App, iOS, Swift. AR/VR. You have to resolve a bug in my iOS App developed using Swift language. I would be happy to share more details thru' chat but I want direct developer, who can be available online and check the code, run the App, fix the issue and work with me. Revise as many times as i want till the issue is resolved. Please no beginner, as it is time sensitive project, so i have to get this issue resolved immediately.
I'm experiencing issues with my Excel. The Copy/Cut/Paste functions are disabled, and I need someone to troubleshoot and assist me with these functions. Ideal skills for this job would include: - Expert knowledge of Microsoft Excel - Troubleshooting skills - Data entry experience Please help me get my Excel functioning properly again. Thank you!
I'm looking for a freelancer to assist with data entry from spreadsheets into Microsoft Excel. The data is mixed, consisting of both text and numerical values. Ideal Skills and Experience: - Proficient in Microsoft Excel - Attention to detail - Experience with data entry from spreadsheets - Ability to handle mixed types of data (text and numerical)
I have lost admin login credentials for two websites hosted on a VPS. I need a professional to help reset the admin login access to these sites. Details: - I have root access to the VPS, which means you will be able to access everything needed to reset the logins. - Both websites are hosted on the same server. Please inform me of your capabilities and your best price for resetting the admin user login to each website.
...academic writer with extensive experience in crafting high-quality research papers and theses, particularly in the fields of cybersecurity and artificial intelligence. The project focuses on developing a research paper about "Developing Evaluation Criteria for Cybersecurity Leadership Competencies Using Recommender Systems." The ideal candidate should be capable of designing and implementing a recommender system model using AI techniques while aligning the research with academic standards. Key Requirements: Academic and Technical Expertise: Proven experience in writing academic research, especially in cybersecurity or AI-related fields. Ability to conduct thorough and professional literature reviews. Strong Background in...
I have several transactions that need to be compiled into a billing statement. You will receive: - Transaction details in an Excel/CSV format - A template to follow for the billing statement Your task: - Convert the transactions into a Word and PDF billing statement using the provided template - Include all details I provide, such as client details, billing period summary, and payment instructions Ideal skills: - Proficient in Excel - Experienced in Word and PDF document creation - Attention to detail to ensure all supplied information is accurately included
...seeking a dedicated individual or a team to assist with research into Melbourne-based businesses. Your primary tasks will include subscribing to Sales Navigator (cost covered by me), researching through LinkedIn and the web to locate the Melbourne Office and headcount located in Melbourne and populating an Excel spreadsheet with relevant data. Key Responsibilities is to research Melbourne businesses and fill in the following: - Fill in the spreadsheet with the Melbourne office address - Fill the number of staff located in Melbourne (details provided) The workload is anticipated to be about 400 hours. The ideal candidate for this project should have: - Excellent research skills - Familiarity with LinkedIn and Sales...
I need assistance with modifying two Excel files. The modifications include: 1. Separating headers into individual cells (e.g., Serial Number, Last Name, First Name, etc.). 2. Ensuring the header row is consistent across all pages. 3. Removing empty rows. 4. Deleting duplicate words while preserving the main data integrity. 5. Maintaining the serial number and data alignment. The headers follow a specific format, which is a combination of uppercase and lowercase letters. I can describe this format to you, but I will need your assistance to determine it in some cases.
I have three PDF drawings that need to be analyzed and converted into a Bill of Quantity (BOQ) in an Excel format. The scope of the project includes: Ideal candidates for this project should have a strong understanding of construction and engineering principles, experience in BOQ preparation, and proficiency in Excel. Attention to detail and the ability to accurately interpret engineering drawings are essential for success in this task. BOQ should include the following: construction electric electronic works mechanic earth works site works railway perimeter security civil/mechanical/electrical infrastructure The 3 PDF drawings to be downloaded are in the link below under ATT_13: ATT__13_Drawings_HN_COMBINED
I need assistance in organizing my credit card statements. The ideal freelancer would have experience in data consolidation and categorization. Key tasks include: - Consolidating credit card statements from the last 12 to 24 months - Organizing the statements by expense category - Delivering the final product as a well-structured Excel spreadsheet Skills required: - Proficiency in Excel - Data analysis and categorization - Attention to detail
I need a professional Excel file for comprehensive inventory planning. This includes stock level monitoring, demand forecasting, order management, and raw material safety stock. The Excel file will need to integrate with SAP, specifically for seamless data transfer and process alignment. Key functionalities I need in the Excel file include: - Automated data import: I want the data to flow into the Excel file automatically from SAP, without needing manual input. - Custom reporting: The ability to generate tailored reports based on specific parameters or needs. - Data visualization: Incorporating graphs, charts and other visual aids to help interpret the data. Ideal candidates for this project should have: - Extensive experie...
I'm looking for an expert Excel specialist who can set up a comprehensive spreadsheet for me. The data I will be inputting is a combination of financial and sales tracking information. Key Requirements: - Design and setup of an Excel spreadsheet tailored to track both financial and sales data. - Incorporation of automatic calculations and formulas to facilitate data processing. - Implementation of data visualization tools within the spreadsheet, such as charts and graphs, to illustrate trends and patterns. Ideal Skills: - Extensive experience with Excel, particularly in setting up complex spreadsheets. - Strong understanding of financial and sales data tracking. - Proficiency in creating automatic calculations and data visuali...
...uk/ Objective: To scrape and extract all relevant data from the above website for internal use. The extracted data must be well-organised, accurate, and easy to navigate for future reference. (Wordpress based but do not want to use the WP plugin) Scope of Work: 1. Data to Scrape: • Product details (e.g., product names, descriptions, specifications, features, images, pricing, and PDFs, if available). • Blogs and articles (titles, content, and associated metadata such as publication dates). • Contact details (email, phone, address, etc.). • Any other publicly accessible, relevant information. 2. Data Format: • Deliver all extracted data in a well-structured Excel/CSV format (with clear headings). • Images an...
...talented Front-End Developer to join our busy Development team. You will be instrumental in creating mobile-optimised, user-friendly web applications and delivering high-quality solutions to meet client needs. If you’re ready to make an impact with a company that values innovation and quality, we’d love to hear from you. Key Responsibilities: Collaborate with back-end developers and UI/UX designers to implement and optimise user interfaces. Designing and developing complex web applications using modern technologies and frameworks such as Ionic, React.JS, TypeScript and Next.JS. Experience in building mobile-optimised front-ends for websites. Exposure to mobile development using Ionic, React Nat...
...talented Front-End Developer to join our busy Development team. You will be instrumental in creating mobile-optimised, user-friendly web applications and delivering high-quality solutions to meet client needs. If you’re ready to make an impact with a company that values innovation and quality, we’d love to hear from you. Key Responsibilities: Collaborate with back-end developers and UI/UX designers to implement and optimise user interfaces. Designing and developing complex web applications using modern technologies and frameworks such as Ionic, React.JS, TypeScript and Next.JS. Experience in building mobile-optimised front-ends for websites. Exposure to mobile development using Ionic, React Nat...
I'm in need of an Excel whiz who can help me set up a comprehensive sales tracking system. Key Requirements: - Define daily sales-related tasks for each team member - Create an Excel spreadsheet to monitor these activities - Design a final dashboard to consolidate the data Skills & Experience: - Proficient in Excel with proven experience in sales tracking - Capable of creating user-friendly dashboards - Excellent understanding of sales metrics, particularly the number of sales and client interactions. The ideal candidate will help me track the performance of each of my sales team members, ultimately enhancing our overall sales strategy.
I'm in need of an Excel whiz who can help me set up a comprehensive sales tracking system. Key Requirements: - Define daily sales-related tasks for each team member - Create an Excel spreadsheet to monitor these activities - Design a final dashboard to consolidate the data Skills & Experience: - Proficient in Excel with proven experience in sales tracking - Capable of creating user-friendly dashboards - Excellent understanding of sales metrics, particularly the number of sales and client interactions. The ideal candidate will help me track the performance of each of my sales team members, ultimately enhancing our overall sales strategy.
I'm looking for an Excel expert to develop a program that calculates various real estate market trends. The program should specifically focus on analyzing general market tendencies. It should be a program that can be used numerous times with different data sets. Key Skills: - Advanced Excel skills: You should be proficient in Excel and able to create complex formulas and functions to analyze the data. - Real estate knowledge: A background or understanding of the real estate market would be a plus as it would help you comprehend what data is relevant and how to interpret. Please provide examples of similar projects you have completed.
I need a skilled professional to seamlessly integrate my Microsoft Access Database with a daily-updated Excel sheet. The Excel sheet contains mixed data (text and numbers). Key Tasks: - Daily integration of updates from the Excel sheet into the Access database. This includes both appending new records and updating existing ones. Ideal skills and experience: - Proficient in Microsoft Access and Excel. - Experience with data integration and automation. - Ability to set up a system that requires minimal manual intervention.
I need someone skilled in data entry to help with inputting mixed data (numerical and text) into an Excel sheet. The data needs to be organized in chronological order. I will provide a PDF with data that contains 4 fields to be entered on Excel document. Ideal skills for this project include: - Proficiency in Excel - Excellent attention to detail - Strong organizational skills Please note, there will be no specific date or time formats involved in the data entries.
As a law firm, we're looking for a developer who can create an application for real-time analysis of Twitter, ...application for real-time analysis of Twitter, Facebook, and Instagram posts from a specific area. The app should categorize posts by theme, and generate an Excel file detailing demographic information such as age, gender, location, interests, and the profiles of followers and followees for each segment. The ideal candidate for this project should have: - Extensive experience in app development, particularly for social media analysis. - Proficiency in data segmentation and Excel file generation. - Ability to implement real-time data processing. - Skills in understanding and analyzing demographic data. Your work will help us conduc...
I'm seeking assistance in conducting market research for a potential Mobile Fuel Delivery service in the Dallas-Fort Worth area. 2 Companies to compare it to and Key Responsibilities: - Assess consumer demand for a mobile fuel delivery service - Target research towards families, young professionals, and elderly residents - Design and implement surveys for data collection Ideal Skills: - Experience in market research - Proficiency in survey design and implementation - Understanding of the Dallas-Fort Worth demographic landscape - Excellent data analysis skills
Hello Sir/Madam, my name is Mohammed Shan. With five years of experience in Microsoft excel, I specialize in creating advanced spreadsheets tailored for sales data analysis. I am adept at using Excel formulae and data analysis tools, including the creation of effective - drop lis downts. My strong attention to detail and proven track record in handling complex Excel projects make me a suitable candidate for your needs. I look forward to delivering high-quality results for your project.
I have a 550 sqft cabin and I'm seeking a structural engineer to assess the support for the first floor coming from the basement. I plan to use beams and columns for the first floor support, and I prefer wood for these structures. Ideal Skills and Experience: - Knowledge and experience in structural engineering, specifically in residential properties. - Familiarity with the use of wood in structural applications. - Ability to assess and design the support system using beams and columns. - Previous experience with cabin structures is a plus.
