Find Jobs
Hire Freelancers

Excel Filtering

$10-30 USD

Completed
Posted about 1 year ago

$10-30 USD

Paid on delivery
I have two excel sheets that need to be merged and matched for duplicate. (this is one of 20+ assignments a month if you do this fast) If you find a matching line item in any of the rows, they need to be placed next to each other in the same row. If you don't find a matching row in sheet 1 vs. sheet 2. You will leave the line blank for the individual that does not have a matching line item. I need both sheet lined up row by row in the same sheet. Pleas e take a look at the screenshot provided for reference. I will pay if you can code a program to do it for me automatically. Please feel free to message about your coding skills and capabilities.
Project ID: 36093473

About the project

57 proposals
Remote project
Active 1 yr ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello Chuck, I can assist you to manually compare and merge 2 product lists into one master spreadsheet. Here are my similar merging projects https://www.freelancer.com/projects/excel/Need-very-experienced-Excel-expert https://www.freelancer.com/projects/Data-Entry-Excel/Merge-Spreadsheets-into-one-that https://www.freelancer.com/projects/spreadsheet-merge https://www.freelancer.com/projects/Merge-Spreadsheets https://www.freelancer.com/projects/Data-Entry-Excel/Merge-edit-two-email-lists Please drop a PM if you’re interested. Best regards, Hoang
$10 USD in 2 days
5.0 (174 reviews)
7.2
7.2
57 freelancers are bidding on average $25 USD for this job
User Avatar
Greetings, As a highly skilled Excel specialist with 10 years of experience, I am confident in my ability to complete the Excel job you have to perfection. I have expertise in the following areas: - Formulas and functions: Knowledge of Excel's advanced functions such as INDEX-MATCH, VLOOKUP, HLOOKUP, and IF functions to perform complex calculations. - Pivot tables and charts: Proficiency in creating and formatting pivot tables and pivot charts to analyze large data sets. - Macros and VBA: Proficiency in using macros and VBA to automate repetitive tasks and create customized solutions. Data cleaning: Capability to clean and transform data using Excel's built-in functions and tools such as Text-to-Columns, Find and Replace, and Remove Duplicates. - Data modeling: Capability to create complex models to forecast future trends, estimate budgets, or calculate financial metrics such as ROI, IRR, and NPV. I believe that my knowledge and expertise make me an ideal candidate for this position and your job of Excel Filtering . Thank you for considering my application. I look forward to hearing from you soon. Regards, Mohamed Fawzy
$25 USD in 1 day
5.0 (136 reviews)
10.0
10.0
User Avatar
Hi, I'm an Expert Virtual Assistant providing services of Data Entry, Web Research, Data Mining, Data Processing, PDF conversion, Microsoft Office work, Photoshop work, and much more! I have experience of more than 2 years of in the Freelancing field. With my skills and expertise, I can guarantee 100% success rate in your project. I have a deep understanding of the requirements of this project and I'm confident that I can provide you with the best results. Additionally, I provide regular updates during the project so that you don't have to worry about anything. Please feel free to contact me if you have any questions or would like to discuss this opportunity further. All the best, Muhammad Ali
$10 USD in 1 day
5.0 (140 reviews)
6.7
6.7
User Avatar
Hello, I'm interested in your project. Your task is clear to me and I am ready to solve it. I have extensive and successful practical experience in processing and analyzing data in Excel, including using formulas and macros.
$25 USD in 1 day
4.9 (131 reviews)
6.6
6.6
User Avatar
Greetings Thanks for checking my proposal. I would match both sheets accordingly and and can start your project immediately. I am full- time freelancer having job experience of more than two decades. It included more than decade of experience as Manager Accounts in Public Listed Companies. Having In depth knowledge of Excel for data analysis, Pivot Table and charts, Dashboard, Power query, Macros, User Forms, Advance filters, VBA, Excel Solver, Advance dynamic charts, Financial reporting by using complex Functions. I have also developed many softwares in MS Access. It is my practice to do one project at a time therefore I would assist you full time according to your available time. You can check my scores and reviews Hoping for the positive reply from your side for a long-lasting working relationship. Regards
$17 USD in 1 day
5.0 (127 reviews)
6.2
6.2
User Avatar
Hi I can help to do this job and can start work right now. Can do fast. I have 16+ year experience of Excel, Excel VBA and Have 100% feedback So, you can trust me. Result will be as you need Best Regards
$20 USD in 1 day
5.0 (71 reviews)
5.5
5.5
User Avatar
Hello, I'm a former CP (competitive programming) competitor, I'm a master at algorithms and could help you solve your problem quickly with clean, optimized and well-commented code.
$20 USD in 1 day
5.0 (43 reviews)
5.5
5.5
User Avatar
Greetings! I can help you with your project at a high level! I have lots of experience in Excel VBA. My skills and experience is a great match for your needs. Looking forward to hearing from you. Best regards.
$20 USD in 1 day
4.9 (38 reviews)
5.6
5.6
User Avatar
Hello, I'm an experience Cost & Management Accountant with having an Advanced Level expertise in Microsoft Excel and would like to help you to in this project. Please message me so we can discuss this further before starting officially. Thanking You!
$20 USD in 7 days
5.0 (73 reviews)
5.4
5.4
User Avatar
Sir, Problem is solved through the very easy formula... VEry easy work for me... I have two excel sheets that need to be merged and matched for duplicate. (this is one of 20+ assignments a month if you do this fast) I have two excel sheets that need to be merged and matched for duplicate. (this is one of 20+ assignments a month if you do this fast)
$20 USD in 1 day
4.8 (103 reviews)
5.3
5.3
User Avatar
Hi, I have gone through the Job details and am interested in taking it up. I’m Ahmed Hassanein. I’ve been working with MS Office since the 90’s as a user, developer, and trainer. I've been using formulas, VBA, and macros in Excel since 2004. I completed Excel VBA and Google Sheets Apps Script jobs for happy customers (check my job reviews). I would be happy if we connect to talk more about your Job and discuss how I can help you accomplish it. Thank you and kind regards, Ahmed Hassanein
$30 USD in 2 days
5.0 (32 reviews)
5.2
5.2
User Avatar
Hi, professional programmer and ready to code a script/macro to do it automatically whenever you need. This would be much better to save time/money.
$50 USD in 1 day
4.9 (17 reviews)
4.9
4.9
User Avatar
I am an accounting,STATS, economics, marketing and finance and excel expert with success in maintaining and organizing data, including dictionaries, metadata repositories, and cross-reference indexes across a broad range of industries. Skilled in VLOOKUP formula development, Pivot Table generation, and Pivot reporting. Demonstrated ability to use critical and strategic thinking to resolve discrepancies, fill gaps, and sustain quality control benchmarks. Check my portfolio for samples. I have a strong command of SPSS, STATA, Excel, minitab,R programming and MPLUS. Some of my recent projects include. Designed survey research studies including questionnaire development, sample selection, checking survey results, conducted SAS programming, statistical analyses, and data reporting • Implemented survey methodology that increased response rates by 37% • Implemented an automated survey scanning system that reduced the need for data entry personnel by 70% • Additional duties included writing technical reports and making presentations based on survey data, survey development and implementation, monitoring of data collection, and sample management
$50 USD in 1 day
5.0 (12 reviews)
4.9
4.9
User Avatar
✅ Excel Expert ✅ Microsoft Office Certifier ✅ Surely Delivery in 2 Days ✅ Immediate Start ✅ Offering you Professional IT Experience in Excel, data mining, web searching, Web scrapping and lead generation with over 5+ years experience working in all domains. What do we offer? ✅ Will update you in excel as you need. ✅ Daily work updates. ✅ Quality Work with 99.99% Accuracy ✅ Always on time ✅ Excellent Support. ⭐ Previous work available on request. I would be glad to bring my skill-set and expertise to work with you on your project. Feel free to send me a message to discuss your project with me, and I will respond right away!!! ? Hard work always appreciated ? Thanks & Regards, Pooja G.
$70 USD in 2 days
5.0 (17 reviews)
4.4
4.4
User Avatar
Hi There, Hope you are doing well, Interested in your posting as I’m used to performing such projects (See Profile + https://www.freelancer.com/get/Leozida?f=givepc). Already drafted by formula - I’m available and ready to share it if you give me a chance. Please open a chat to see it I would like to assist you at a reasonable price along with high-quality work delivered on time. Looking to hearing from you soon, My experience does not always translate into more money but it definitely helps :) Thanks & Regards, Leo,
$15 USD in 1 day
4.9 (25 reviews)
3.9
3.9
User Avatar
Hello, I have almost 15+ years of hands-on programming experience in excel automation. Can help you out in your requirement.
$20 USD in 7 days
5.0 (1 review)
2.7
2.7
User Avatar
Hi I could absolutely automate this for you in excel Visual Basic. Why not jump on a call and I can talk you through how this could be done and I could get started right away. I have extensive experience using excel and coding in vba, I hope this is portrayed in my profile. I could turn this around very quickly for you, when did you require the finished solution. Regards Jamie
$20 USD in 7 days
5.0 (1 review)
1.8
1.8
User Avatar
Hello mate ! I saw the details of your project and I have experience of PHP, Visual Basic, Data Processing, Excel, Software Architecture of 5 years. I believe I can get this done for you as per the requirements and keeping it all budget friendly. Our team of experts can work on PHP and provide satisfactory results. Our first priority is to make sure we understand your project and deliver as per your needs also keeping in mind your budget. Hit me up so we can discuss further details Looking forward
$10 USD in 1 day
5.0 (1 review)
1.4
1.4
User Avatar
Hi, In your job posting you are looking for a person who knew every basics of data entry work specially MS excel. I have gone through the project details carefully and would like to tell you that I have all the required skills (vlookup, hlookup, pivot table, macro etc.) that you posted in the description. I would like to offer myself as a candidate for the job. Thanks Bhawan Duklan
$15 USD in 2 days
5.0 (2 reviews)
1.2
1.2
User Avatar
Dear Hiring Manager, I have all the required skills like MS Excel, MS word, Tally for GST, Tally ERP, and working in google sheets too. As being a skilled data entry employee I would like to offer myself as a candidate for the job. It’s been almost 2 years since I’m working with data entry, data importing, data exporting, and data analysis. In these 2 years, I have worked with lots of people and companies, making me a skilled and experienced data entry worker. My typing speed has also proven satisfactory to all my old clients. For knowing more about my skills you are requested to visit my profile (https://www.freelancer.com/u/ranjithgvarun96) and read my satisfactory portfolio of me. Your job made me so curious that I just can’t wait to have the job and complete it quickly and properly. So, all I want you to allow me to prove myself for the work. You can connect with me for further assistance. I can assure you that I’ll be available for more than 40 hours a week. And I’m willing to start your job as soon as you let me do the work, waiting for your responses please let me know if you are interested in hiring me. Thank you, Ranjith G Varun
$10 USD in 2 days
4.8 (6 reviews)
0.7
0.7
User Avatar
I am a hard-working and driven individual who isn't afraid to face a challenge. I'm passionate about my work and I know how to get the job done. I would describe myself as an open and honest person who doesn't believe in misleading other people and tries to be fair in everything I do.
$20 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Winnetka, United States
5.0
3
Payment method verified
Member since Jan 24, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.