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.

Evner: Databehandling, Excel, Microsoft Access

Se mere: 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

Om arbejdsgiveren:
( 3 bedømmelser ) Weatherford, United States

Projekt ID: #18114823

Tildelt til:


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 Flere

$60 USD in 0 dage
(775 bedømmelser)

39 freelancere byder i gennemsnit $76 på dette 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 freelancer.com and have been featured by the freelancer community ( Flere

$150 USD in 2 dage
(633 bedømmelser)

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 Flere

$140 USD in 3 dage
(288 bedømmelser)

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 Flere

$100 USD på 1 dag
(273 bedømmelser)

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 Flere

$135 USD in 2 dage
(258 bedømmelser)

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 dage
(282 bedømmelser)

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 på 1 dag
(187 bedømmelser)

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 dage
(131 bedømmelser)

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 dage
(187 bedømmelser)

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 dage
(202 bedømmelser)

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 dage
(72 bedømmelser)

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 Flere

$155 USD in 3 dage
(92 bedømmelser)

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 Flere

$155 USD in 3 dage
(65 bedømmelser)

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 Flere

$35 USD på 1 dag
(145 bedømmelser)

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 på 1 dag
(34 bedømmelser)

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 dage
(63 bedømmelser)

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 Flere

$60 USD in 2 dage
(130 bedømmelser)
$40 USD på 1 dag
(56 bedømmelser)

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 Flere

$30 USD in 3 dage
(45 bedømmelser)

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 Flere

$30 USD på 1 dag
(98 bedømmelser)

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 Flere

$194 USD in 3 dage
(54 bedømmelser)