Lengkap

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.

Kemahiran: Pemprosesan Data, Excel, Microsoft Access

Lihat lagi: 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

Tentang Majikan:
( 3 ulasan ) Weatherford, United States

ID Projek: #18114823

Dianugerahkan kepada:

cgullapalli

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 Lagi

$60 USD dalam 0 hari
(775 Ulasan)
7.8

39 pekerja bebas membida secara purata $76 untuk pekerjaan ini

jaylancer43

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 ( Lagi

$150 USD dalam 2 hari
(633 Ulasan)
8.3
schoudhary1553

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 Lagi

$140 USD dalam 3 hari
(288 Ulasan)
7.7
seaanddream

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 Lagi

$100 USD dalam sehari
(273 Ulasan)
7.7
zExcel

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 Lagi

$135 USD dalam 2 hari
(258 Ulasan)
7.6
P0L

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 dalam 3 hari
(282 Ulasan)
7.2
sergiuloghin

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 dalam sehari
(187 Ulasan)
7.3
hdlong66

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 dalam 0 hari
(131 Ulasan)
6.8
priyal1997

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 dalam 0 hari
(187 Ulasan)
6.7
asifdwan

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 dalam 5 hari
(202 Ulasan)
7.0
Beacon09

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 dalam 2 hari
(72 Ulasan)
6.6
zekovicm

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 Lagi

$155 USD dalam 3 hari
(92 Ulasan)
6.9
periyannas

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 Lagi

$155 USD dalam 3 hari
(65 Ulasan)
5.9
MdAlamgirHoosain

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 Lagi

$35 USD dalam sehari
(145 Ulasan)
5.8
expertcoder1vw

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 dalam sehari
(34 Ulasan)
5.6
macroPOL

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 dalam 3 hari
(63 Ulasan)
5.6
vlayausa

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 Lagi

$60 USD dalam 2 hari
(130 Ulasan)
5.8
$40 USD dalam sehari
(56 Ulasan)
5.7
aimefx

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 Lagi

$30 USD dalam 3 hari
(45 Ulasan)
5.5
beltran0404

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 Lagi

$30 USD dalam sehari
(98 Ulasan)
5.2
sonarkaushik

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 Lagi

$194 USD dalam 3 hari
(54 Ulasan)
5.8