Find Jobs
Hire Freelancers

De-dupe large Excel spreadsheet

$30-250 USD

Completed
Posted over 5 years ago

$30-250 USD

Paid on delivery
I am comparing inventory lists from previous year to current year, and I use Excel's conditional formatting to identify duplicate values between two columns of data. Each column contains over 40,000 rows of data. I need to sort the data in column A with unique values at the top. When I attempt to do so, Excel crashes as the sort is too resource-intensive. I need to group all the unique values in column A together.
Project ID: 18114823

About the project

36 proposals
Remote project
Active 5 yrs 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
HI, I am good at Excel vba and formulas. I have referred the attached file. I would like to discuss more to see the sorting options you are using and necessity of conditional formatting. I can try suggesting better alternatives. -Chandra
$60 USD in 0 day
5.0 (1226 reviews)
8.5
8.5
36 freelancers are bidding on average $77 USD for this job
User Avatar
Hello! I can create a formula for you and resolve the problem for your large spreadsheet. Can you award me? I can start now and finish quick. you will not be dissapointed, I have a big 34% rehire rate. Thank you!
$55 USD in 1 day
5.0 (463 reviews)
8.4
8.4
User Avatar
Hello, Hope you are doing well. I can help with you in your project De-dupe large Excel spreadsheet. I can assure you the quality job. I have good experience in Data Processing, Excel, Microsoft Access. We have worked on several similar projects before! We have worked on 400+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$140 USD in 3 days
4.9 (577 reviews)
8.5
8.5
User Avatar
Hi, my name is Selim. I read your `De-dupe large Excel spreadsheet` project descriptions carefully before bidding. I checked your requirements as well... I got what you need and ready to go ahead as soon as we can clarify further project details. I am 5-star excel and vba coding expert here at freelancer.com. Pls check my profile and feedbacks first to have some idea about the quality of my previous businesses. I had many similar excel tasks, including automated data extraction, aggregation and reporting, all achieved with 5/5 rating. Kindly get back to me if you wish to proceed with a top-rated and reliable partner here...pls note that I only deliver best quality at a reasonable price, and I am open for longterm partnerships, if you wish too... I bid my best for you to start business, and I am ready to prepare an excel workbook template for you to check & validate, once you give me a reply...regards.
$100 USD in 1 day
5.0 (318 reviews)
8.2
8.2
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$100 USD in 3 days
5.0 (511 reviews)
8.1
8.1
User Avatar
Hi there,I am Miljan,Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
$155 USD in 3 days
4.9 (175 reviews)
7.9
7.9
User Avatar
I'd be happy to help you with this project. I'm experienced with all Excel functions including advanced formulas and macros and I have an excellent record of quick turnaround time. Just let me know when you're ready and I will start right away.
$135 USD in 2 days
4.9 (260 reviews)
7.7
7.7
User Avatar
I'm an Excel / database expert and can dedupe the spreadsheet for you. Can deliver in 1 day or less. Good quality work done. Thanks for considering me. Bests, Steve
$30 USD in 1 day
5.0 (72 reviews)
7.5
7.5
User Avatar
Hi there! Can we discuss? I'm an expert in data entry and data scraping jobs. I've huge experience in working on this type projects. Look forward to hearing from you. Regards
$250 USD in 5 days
4.8 (267 reviews)
7.3
7.3
User Avatar
Dear Sir This is Md Alamgir,expert in Data Entry, Excel.I have 5 years experience in this field.I have a experienced team of 8 members and able to do this very short time.I have good command in conditional formatting and another method. I will do this 100% accuracyPlease award me.
$35 USD in 1 day
4.9 (319 reviews)
7.3
7.3
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fifty excel vba projects in the recent eight months. Ok. Sure. Let me help. Willing to take up your project. Thank you, Regards.
$155 USD in 3 days
5.0 (191 reviews)
7.1
7.1
User Avatar
Hello, I have a solution for sorting your data. It took 5 minutes for sorting on my comp. I can show you how if you’re interested. Best regards, Hoang
$30 USD in 0 day
5.0 (173 reviews)
7.2
7.2
User Avatar
Hi There, I can do this task perfectly within few minutes for you. You can refer my profile if you have any doubt Looking forward to start the project soon. Best regards Priyal
$30 USD in 0 day
5.0 (199 reviews)
6.7
6.7
User Avatar
Hi, Understood. I can remove duplicates and double check the results. I have experience of completing several similar tasks. Looking forward to seeing your reply. Thanks. Regards Ahsan
$130 USD in 2 days
4.9 (77 reviews)
6.7
6.7
User Avatar
Hello, I can do the job you want in excel as i have advanced excel skills and over 8 years in the field. Please check my portfolio to see my work. Thanks!
$140 USD in 3 days
4.9 (70 reviews)
6.9
6.9
User Avatar
I am a professional accountant with a decade of experience working in a US based NASDAQ registered company's finance department with excellent excel skills and knowledge.
$50 USD in 3 days
4.9 (125 reviews)
6.3
6.3
User Avatar
Hello, I am Excel and VBA expert. I can do it by VBA (macro). Please note that I have 100% completion rate and 5-star feedback on over 50 projects. Jan
$60 USD in 3 days
5.0 (94 reviews)
6.1
6.1
User Avatar
I am interested in your project about data entry of 40,000 rows of data. If you give me chance then Kindly message me so we can start right now.
$30 USD in 1 day
4.9 (91 reviews)
5.9
5.9
User Avatar
Hello, I am proficient with Excel and VBA and would love to help with this issue. I have a lot of experience with similar problems and I could solve this for you pretty quick. Please contact me for more information.
$60 USD in 2 days
4.9 (143 reviews)
5.9
5.9
User Avatar
Hello, I am Luis from Venezuela and it will be my pleasure to help you with this project. I can assist you with your current Excel issue. Please contact me by chat and then we could discuss further details about your project! Kind regards, Luis Romero
$30 USD in 1 day
5.0 (170 reviews)
6.0
6.0
User Avatar
Hi, I am an excel expert I can group all unique values in column A or other columns using excel power query. Please send me a message, If you are interested I'll complete for free and will send you after checking the result you can award me. Thanks
$30 USD in 3 days
4.9 (107 reviews)
6.3
6.3

About the client

Flag of UNITED STATES
Weatherford, United States
5.0
4
Payment method verified
Member since Mar 20, 2007

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.