De-dupe large Excel spreadsheet

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.

Skills: Data Processing, Excel, Microsoft Access

See more: large excel files, excel spreadsheet quickbooks, send bulk mail excel spreadsheet, excel remove duplicates keep first, excel remove duplicates formula, how to remove duplicates in excel 2016, find unique values in excel multiple columns, how to identify duplicates in excel, excel remove duplicate rows based on one column, how do you find but not remove duplicates in excel?, how to delete duplicates in excel but keep one, reformat excel spreadsheet, year plan excel spreadsheet, excel spreadsheet surgery cost, convert excel spreadsheet label, convert excel spreadsheet standalone application, multi level marketing pay plans excel spreadsheet, parse word document excel spreadsheet, excel spreadsheet vba data entry form, copy paste excel spreadsheet

About the Employer:
( 3 reviews ) Weatherford, United States

Project ID: #18114823

Awarded to:


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 bet More

$60 USD in 0 days
(775 Reviews)

39 freelancers are bidding on average $76 for this job


Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on and have been featured by the freelancer community ( More

$150 USD in 2 days
(633 Reviews)

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 hav More

$140 USD in 3 days
(288 Reviews)

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 cl More

$100 USD in 1 day
(273 Reviews)

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 a More

$135 USD in 2 days
(258 Reviews)

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
(282 Reviews)

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
(187 Reviews)

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 days
(131 Reviews)

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 days
(187 Reviews)

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
(202 Reviews)

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
(72 Reviews)

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 ag More

$155 USD in 3 days
(92 Reviews)

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 More

$155 USD in 3 days
(65 Reviews)

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 More

$35 USD in 1 day
(145 Reviews)

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
(34 Reviews)

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
(63 Reviews)

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 inform More

$60 USD in 2 days
(130 Reviews)
$40 USD in 1 day
(56 Reviews)

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 More

$30 USD in 3 days
(45 Reviews)

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 you More

$30 USD in 1 day
(98 Reviews)

Sir, I am well versed in these kind of jobs and can do your project as per your requirement. I am very much able to work on this. ***I am ready to start Message me for further discussion. Waiting to hear from More

$194 USD in 3 days
(54 Reviews)