How to find duplicate values in two columns in excel jobs

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

More details: Our projects starting price is $4000 to $10000 for website development clients (Realestate, Wellness, Clinic, Coaching) you need to find people who can afford and buy this service

...permits. Here is a link to the database: Please go over all of the records, and filter ones that match all criteria: 1. EIA Screening Application/Statement or EIA Scoping Application/Statement and 2. The application is for an activity in the sea Start a new spreadsheet, and for every such record, meeting the above criteria, add a row to the spreadsheet including: date of the record, screening/scoping, title of the application (translated to English), a url linking to the application on the NEA website. In addition, download the screening/scoping report document, translate it to English with Google translate, and provide it as well. Start the search from most recent and search backwards in time. Once you find 30 sea-rel...

I need an advanced Excel wizard to craft a spreadsheet consisting of 1-5 sheets handling participant demographic data. The spreadsheet must be capable of: - Data Analysis: Analyzing and interpreting patterns for more effective decisions. - Automated Calculations: Creating mathematical formulas to execute automatic calculations. - Conditional Formatting: Highlighting specific data points based on pre-set conditions. Preferred attributes: - Strong analytical skills - Proven experience in Excel - Data interpretation ability - Solid understanding of data privacy standards. Also instructions on how can I replicate what was done, so I can be prepared to answer any questions needed. There are two spreadsheets one for asmp and one for SIR....

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

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

...and need a skilled video editor to help me with the post-production. The goal is to create engaging content that can be shared on platforms like TikTok and Instagram. Key Requirements: - Advanced editing skills: I'm looking for someone who can enhance my content by adding effects and transitions. - Understanding of young adult audience: The primary target for these videos are individuals aged 18-25, so a creative approach that resonates with this demographic is key. - Sensitivity to content: As these videos will document my personal journey with cancer, it's important that the editor is empathetic and able to handle the sensitive nature of the topic. Future Opportunity: The ultimate goal of these videos is to build a following that I can ...

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

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

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

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

I'm in need of a logo design. I want a stylish, sophisticated logo featuring a raven in an art deco style. The raven should be flying in a north-east direction. The design requirements are as follows: - The color scheme should predominantly be a mix of deep blue and black, with the option of using midnight blue as well. - The art deco style should be based on geometric shapes, symmetry, and abstract motifs. Please ensure that the design is sophisticated and not cartoonish or childish. - The font used in the logo should be simple and elegant. I have attached several examples of logos that I find visually appealing in this regard for reference. need to be in also in pdf, vector. Ideal Skills for this project: - Experienc...

The logo needs to feature hands behind held in some way symbolizing the concept of 'Hanai' — embracing someone into the family. The design is minimalistic, focusing on smooth, clean lines to keep it casual and approachable. Color Scheme: Blue: A calming, light shade of blue to convey trust and dependability. This color could be used for the hand, enhancing the feeling of security and professionalism. Orange: A soft, cheerful shade of orange that contrasts with the blue, used for the medical symbol to inject vitality and warmth into the design. Usage: The design’s simplicity ensures broad versatility across digital and print mediums, maintaining clarity and impact whether scaled down for small items like business cards or enlarged ...

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

Create an executable scraper in Python that can extract the SKU (product) list from the following Indonesian online grocery apps: - Astro - Sayurbox - Segari The scraper must be IP-block tolerant, meaning if the scraper gets blocked, execution can be continued from the point where the last row of data was successfully extracted. Scraper Functions Function: list_category_tree Input: competitor_name(astro | sayurbox | segari), existing_csv (optional - CSV file to append to for continuing execution, if the scraper stopped or got IP blocked) Output: CSV of category tree with the following columns (scrape_date, URL, category name, position index, parent_category (null if top level)) Function: extract_sku Input: competitor_name, location (autocomplete place from...

...looking for someone to manage our ads on Facebook, Instagram, and Twitter for the goal of converting sales. We use Adroll for our restargeting that you will need to manage, along with retargeting through social media. We have a product to market, and also three features of our product that we want to specifically market and target with specific ads. We have a list of customers that can be used for like audiences. Finally, we have some events that we want to target with Geo fencing - about two events per month We have creative done for several ad sizes, but no video yet. We have a graphics person on staff to provide additional jpg ads as you request, and are willing to pay for video ads. We also will provide headline and descr...

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

I am attaching my resume . Need to align and edit this. I'm seeking an experienced and creative individual to revamp the formatting and design of my resume. I'm targeting a career move within the technology industry, therefore, I require the design to reflect a high level of professionalism and demonstrate a modern aesthetic. Ideal skills and experience for this task include: - Extensive experience in designing resumes specifically for the technology industry. - Expertise in modern and professional design themes. - Ability to reflect my professional values and skills effectively through design. Your task will not include editing the content or wording of my resume. Your primary focus will be on the visual appeal and readability...

...improving our security, I'm in need of a professional with expertise in the field of hacking and system security. The primary responsibility of this role is to rigorously test the system's security to identify vulnerabilities and suggest enhancements. Key Requirements: - Expertise in network, application, and data security: You should be well-versed in these aspects of security to ensure the entire system is robust. - Ability to identify and address firewall misconfigurations: This is of particular concern, given the specific issues I'm looking to address in the network security. Your role is to simulate various hacking attempts and identify any potential weaknesses in the system's ...

I'm seeking a skilled designer to create a professional 8.5" x 11" printable policy form. The final deliverables should be in PDF format and a compatible Google Docs version. Key details: - The design should be clean and neat with a consistent font and sizing. - Please keep in mind, I have a rough idea and verbiage for the form. PLEASE DO NOT EXACTLY DUPLICATE THE ROUGH IDEA EXAMPLE OR YOUR ENTRY WILL BE REJECTED. Ideal skills and experience: - Expert in Graphic Design - Experience with Google Docs and PDF - Detail-oriented Please note, I'm looking to get this project completed as soon as possible.

...that is accessible and suited for everyday use, including in environments like beaches and pools. Objective: We need a logo that reflects our brand’s modern and youthful essence while also conveying the elegance and sophistication of our jewelry. The logo should appeal primarily to a young demographic that values both style and sustainability. Logo and Typography Requirements: Simplicity and Clarity: The logo should be straightforward and easily recognizable, suitable for use on small surfaces such as jewelry tags and packaging, as well as online platforms. Modern Feel: We're looking for a design that is contemporary and trendy, fitting well with a fashion-forward, young audience. Versatility: The design should be versatile enough to look great o...

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

More details: What specific goals do you have for improving the SEO of your barber website and spa website? Increase website traffic, Improve search engine rankings, Boost online visibility What information should successful freelancers include in their application? Detailed project proposals Which are the primary keywords or key phrases that you want to target for your barber and spa websites? High volume and low competition keywords, Brand-related keywords, Service-specific keywords - Blogs - Lonk nbuilfing - UX DESiGN - HOME - LANDINGS PRODUCRTS - CHECKOUT - PR - FAST LOADING - Citation backlins

Complete Excel Analytical and Descriptive Analysis on provided dataset by Friday 4 pm

I'm in need of a professional who can analyze comprehensive survey data and present the results in a detailed, report that relates to each hypothesis for my thesis research. The analysis is expected to be done using Excel analyses then further descriptive analysis is needed, focusing on summarising the main characteristics of the data and how they prove/disprove each hypothesis. This will involve exploring the responses to the survey questions, identifying patterns, trends, and constructing summary statistics. The key deliverable for this project will be as follows: an Excel spreadsheet with... - raw data in one tab (provided for you in the attached excel document) - cleaned data a separate tab (provided ...

I am offering source codes for 26 unique Android games ready for purchase. Having developed these games, I can guarantee their quality and potential. Potential buyers, such as a budding game developer or a gaming company, would find this extremely beneficial. Ideal Skills and Experience: * Familiarity with Android Game Development * Profit-oriented mindset * Interest in code acquisition * Game re-skinning capabilities would be a plus Since I missed out on detailing game categories and project timeline, I'm open to discuss these and more at the prospective buyer's convenience.

I need an experienced freelancer to assist me in typing data from handwritten notes into an Excel sheet. Key Requirements: - Previous Experience: Please include details of your previous work in this area - Handwriting Deciphering: Due to the nature of the data being handwritten, you'll need to have good skills in deciphering handwriting - Accuracy: It's crucial that the information is entered into the Excel sheet with the highest level of accuracy Looking forward to your application.

I have a series of PDFs with text that needs to be typed into an Excel sheet. The data is mainly textual in nature. Key Requirements: - Data Entry: You'll be responsible for accurately inputting the text from PDFs into the corresponding cells in Excel. Ideal Skills: - Proficiency in Excel: You should be comfortable using Excel and have experience with data entry. - Typing Skills: Fast and accurate typing skills are essential. - Attention to Detail: The data needs to be entered accurately to ensure the integrity of the information. - Familiarity with PDFs: Experience working with PDFs is beneficial. Please note, there are no specific formatting requirements beyond accurate data entry.

...programmer with expertise in the Twitter API and JavaScript for Google Sheets. I require assistance in setting up the Twitter API and need a custom script written for Google Sheets. Here are the specific requirements for the project: Project Objectives: 1. Script Functionality: - Automatically fetch Arabic text from a specified Twitter account and insert it into Column B of a Google Sheet, starting from Row 2. - Retrieve and insert links for images and videos associated with the tweets into Columns C, D, E, and F respectively. 2. Automation and Updates: - The data retrieval process should be automatic and occur in real-time, ensuring the Google Sheets document is updated continuously, irrespective of whether it is currently open. - Include funct...

...exercises. I need to copy them all over to a notion document with a slightly different format. Here is the google sheet — https://docs.google.com/spreadsheets/d/1SCYzmyfXgZfhu4TFkBi0YQzbXjrzl4O-hVyZZ1eo1HQ/edit#gid=0 Here is the notion table (I will provide access to edit) — I need all of the videos from “Jen’s Exercise Demos” copied over with the name, the video url and the howToTips into the correct columns. All of the videos are vimeo links so should have “vimeo” selected in the videoType column Many of the tips have multiple number bullet points, I need there to be 2 lines between each bullet point, as demonstrated in the example rows. Equipment and movement pattern columns are n...

I have a number of scanned documents that contain financial figures. I need someone to accurately type these into an Excel sheet for further analysis. Key Requirements: - Experience with data typing and analysis in Excel, particularly financial data. - Attention to detail is paramount; precision in typing is crucial for the accuracy of the analysis. - Proficiency in English is a must, as the data will be in English and will need to be accurately transcribed. The ideal candidate should have prior experience in financial data entry and analysis, and comfortable working with scanned documents. Your work will be the foundation for subsequent data analysis, so precision and attention to detail is key.

I am seeking an teacher well versed in Excel 2021 to create a comprehensive intermediate-level course. This course will total between 12-15 hours and will be delivered through both video lectures and interactive exercises and quizzes. Here's an overview of the specific topics the course must cover. • Formulas and Functions • Data Analysis and Visualization • Pivot Tables and Charts • Advanced Functions • Named Ranges • Tables • Charts and Slicers The ideal freelancer for this project will possess strong instructional skills, extensive experience with Excel 2021, and a knack for making complex concepts easy to grasp.

I would like to change our "Dedicated Server " " product page to have a layout more like the one of our competitor "Hetzner" We use the "hostlab" template from Themeforest : The idea is to have buttons on the top of the page like 'AMD Servers" "Intel Servers" "Budget Servers" "Storage Servers" Once clicked, these buttons would load the corresponding Server and details displayed in vertical columns instead of horizontal ones as it is now. Having the same king of drop down menu as hetzner to show/hide some features is also a plus.

I'm looking for a talented graphic designer who specializes in logo creation. I have a particular vision in mind - Key Requirements: - Expertise in Logo Design - Experience in creating Pictorial Mark logos - Ability to incorporate elements of Animals, Objects and Nature It is important that you understand the balance of creating a logo that is both aesthetically pleasing and signifies the integral values and personality of a brand. The ideal freelancer for this project should have a significant portfolio of previous pictorial logo design works and boast a creative flair that matches our vision. Let's connect and bring this vision to life!

I need assistance with a small-scale copy and paste data entry task. The data is less than 1,000 rows and is in a spreadsheet format. Ideal Skills and Experience: - Proficiency in spreadsheet software such as Excel or Google Sheets - Attention to detail to ensure accurate data entry - Efficiency in copy and paste tasks to complete the job promptly This is Medium Task for 1 day Max and will be Fixed Price of 800RS. We have to Refer the Raw File and Practice test for the Students and will it in the correct format in the Practice Bulk upload

I'm looking to create an engaging and visually appealing 'Meet the Team' video that will promote our company culture. Key Elements: - The video should aim to introduce team members to clients, showcasing our vibrant company culture, values, and team spirit. - I envision a creative montage with music to highlight the unique aspects of our team and working environment. Requirements: - The video should be approximately 1 minute and 30 seconds. - No specific locations are needed for filming as the focus will be on my department people. Skills and Experience: - Proven experience in video production, particularly in creating promotional or company culture videos. - Ability to edit and produce a creative montage with suitab...

I have code for login trading accound and fetch token data. I need to update more data from the code to my system.I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Need ot automate the buy/sell order Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 600 INR an...

...talented designer to create a comprehensive brand guidelines document for my real estate company. The primary goal of this project is to ensure consistency in our brand representation across all platforms. Key Deliverables: - A detailed brand guidelines document: This document will serve as a blueprint for our brand identity to be shared with partners, ensuring that our core values and visual elements are consistently represented. - Format: The guidelines are to be presented in PDF format for easy distribution and access. Ideal Skills and Experience: - Proven experience in creating brand guidelines for companies - Strong understanding of visual identity, color theory, and typography - Ability to interpret and translate br...

I have a project where I need you to work with numbers in an Excel sheet. Ideal Expertise: - Proficiency in data entry - Strong knowledge of Excel - Attention to detail - Ability to maintain accuracy and consistency in data entry - Proven experience in similar projects - Able to meet deadlines Please let me know if this is something you can assist with.

Please Sign Up or Login to see details.

I'm in need of an experienced graphic designer who can help me create a modern and professional logo along with brand color scheme for my product/service. Priority is ensuring proper contrast of the main color with white or dark gray to meet accessibility and readability guidelines. Product Description: The product, called CostMate, is a system designed for managing employee and client relationships within a service-oriented company. It also serves as a tool for project cost management and reporting. Color scheme guidelines: The main color should be chosen to maintain a contrast ratio of at least 4.5:1 with white or dark gray. The design should balance aesthetics and functionality to ensure a cohesive brand image. Originality and creativity are welcome, ...

I have a set of customer data in Excel spreadsheets that needs to be cleaned. The data has issues like duplicate entries, incorrect information, and missing values that need to be addressed. Ideal Skills: - Experience with customer data cleaning - Proficiency in Excel and data management - Attention to detail to identify and rectify duplications and inaccuracies - Ability to handle missing values effectively and efficiently. The right freelancer should be able to work with precision to ensure the data is accurate and usable. Please share your experience and approach to data cleaning when bidding.

...entrepreneur, I'm seeking a skilled web designer to develop a minimalistic, clean and functional e-commerce website for my business. I currently own the domain, so I need someone that can take my ideas and turn them into an engaging digital storefront. Key Features: - Shopping cart and checkout functionality for customers to make smooth and secure purchases. - Customer reviews section to allow for feedback and to build trust with prospective buyers. - Advanced product search and filter to help customers navigate and find exactly what they're looking for swiftly. - A dedicated offer page to frequently update customers about sales, deals or new product launches. Skills & Experience: - Proficient in creating minimalist...

...create effective campaigns on Facebook, Instagram, and LinkedIn. The primary aim of these campaigns should be to generate leads and target Indian parents who would be interested in our English-speaking courses for their kids, specifically within the 15-30 age bracket. Ideal skills and experience that would be beneficial include: - Proven track results in lead generation via social media platforms - Experience in the education sector would be a plus - Proficient in targeting and engaging Indian parents - Understanding of Indian culture and education values - Comprehensive knowledge of advertising English language courses. The chosen freelancer should come up with innovative strategies to connect with our target audience meaningfully a...

I have 3 construction programs currently in Excel that I need to be converted into Microsoft Project. The programs are primarily focused on project scheduling and do not require resource management features. Key requirements: - Convert 3 construction programs from Excel to Microsoft Project - Create interactive Gantt charts with dependencies - No need for resource management features, just the scheduling aspect Ideal skills/experience for this project: - Proficiency in Microsoft Project - Experience in project scheduling and Gantt chart creation - Previous work in construction or similar industries would be beneficial Feel free to ask me if you need any further details.

I'm looking to have a website built that will serve as a platform to showcase our car inventory. This website is crucial for our business as it will be the central point for potential customers to peruse and get to know the cars we have on offer. Key Features: - The primary function of this platform is to showcase our car inventory. Therefore, the main focus should be on the design that will effectively showcase the cars in the best possible light. - I would like the website to have a user-friendly search and filter option. This is important as it will allow our clients to easily find the car they are looking for. - It's important that the site is designed to be responsive across various devices to e...

I need an expert in Power BI data analysis who is also adept at implementing AI technologies in the field. Key Responsibilities: - Data Cleaning and Preparation: I need you to clean and organize the data so that it is ready for analysis; this includes removing any irrelevant data, managing missing values, and dealing with inconsistencies. - Data Visualization and Dashboard Creation: You should be proficient in creating visually appealing and insightful dashboards using Power BI. - Machine Learning Model Implementation: I need you to apply machine learning models to the data to predict outcomes or discover patterns, and then integrate these models into the Power BI dashboard. Data Type: The data you will be working with is structure...

...detail-oriented researcher to help me gather information on EU and UK investment figures. Requirements: (1.) The no. of people (and total and average volumes (in EUR)) making personal investments each year in the UK (and separately in the EU) by category - stocks, bonds, crypto, on-line investment platforms (and sub-category real estate platforms - debt and equity), crowdfunding platforms, gold, REITS/real estate funds, savings accounts (banks), current accounts (banks), and "other" (2.) Numbers of households (or people if easier) earning between 50,000 and 100,000 or around those numbers." The numbers can come first - I need these urgently - charts can come later. Time is critical - ideally 24 hours. - Sector-wise breakdown: I am partic...

I require a meticulous professional to help transfer text data from a series of printed documents into an Excel sheet. There's no special symbols or diagrams at all, just plain text. Ideal Skills and Experience: - Thorough understanding of Microsoft Excel - Attention to detail - Proven experience of working with printed documents - Excellent typing speed with the high level of accuracy The project needs to be completed accurately with consistency and timely manner.

I'm in urgent need of a seasoned expert in Microsoft Excel, particularly in creating financial models with emphasis on cash flow management. The ideal freelancer for this project should have proven experience in constructing similar tools for businesses. Key Areas of Focus: 1. Housemaid Cash Flow Tracker: This spreadsheet will facilitate tracking cash provided to our two housemaids and matching their submitted invoices. With three team members involved, it needs to be straightforward and efficient. 2. Monthly Household Budget Expenses: This spreadsheet will serve as a comprehensive monthly budget for all household expenses, including groceries, Amazon purchases, and payments to other suppliers. I envision a format where ...