Do SUMIFs, Remove Duplicates, Search and Replace and Process Data in Excel

$14-30 NZD

İptal edildi

İlan edilme:

9 yıldan fazla önce

$14-30 NZD

Teslimde ödenir

I have a some spreadsheets with a huge amount of data in. The data relates to hundreds of thousands of products and the excel spreadsheets are massive. The steps that I need completing are: 1. Add new sheet within excel doc 2. Copy all keywords from first sheet, place in Column A and then remove all duplicates 3. Copy all keywords from Column A and paste in Column B 4. Search and Replace in Column B for + and delete (don't replace with anything) 5. Use the Trim formula in Column C and trim the data in Column B so that there is no space ahead of any of the data 6. Copy Column C and paste values in Column B. Delete Column C. - You should now have 2 columns with the original keywords in Column A and the trimmed data and no + in Column B 7. Use SUMIF function to sumif all data for each keyword for Column from original sheet to new sheet. 8. Once you have done this, copy all and paste values over the top. I only have 4 files but these files are over 10MB so processing takes a while. Here is an example [login to view URL] that I have already started. I have completed the SUMIFs halfway down the results, but not completed them. The last full row shows all the functions that you can utilise. I will give the winning bidder a link to the dropbox folder where all the files are stored but there are 3 in addition to the Games one that I have attached here.

Excel

Proje No: 6366547

Proje hakkında

34 teklif

Uzaktan proje

Son aktiviteden bu yana geçen zaman 10 yıl önce

Biraz para mı kazanmak istiyorsunuz?

E-posta adresi

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin

Çalışmanız için ödeme alın

Teklifinizin ana hatlarını belirleyin

Kaydolmak ve işlere teklif vermek ücretsizdir

34 freelancers are bidding on average $24 NZD for this job

@Teloquence

Excel expert at your service. I can help you with all the mentioned tasks. Please check my past reviews for your reference. Eagerly waiting for your reply so that I can start with the implementation.

$30 NZD 0 gün içinde

4,9

(330 değerlendirme)

7,7

@hdlong66

Hello. I have powerfull comp and it takes about 1.5-2 hours for calculating each file. Let me handle this project. Best regards Hoang

$14 NZD 1 gün içinde

5,0

(158 değerlendirme)

7,1

@priyal1997

Dear Sir/Madam, As one of the most trusted excel experts in this site, I am happy to help you on this task. Just send me the access to your data file, and I will do it first. Then if you are done, you can offer me the job. If you have any doubt, you can visit my profile to see my qualifications, experience and reliability. I look forward to hearing from you soon. Best regards, Priyal

$25 NZD 1 gün içinde

5,0

(190 değerlendirme)

6,7

@best4best

Excel expert, ready to start this project. Please choose me and send the dropbox link, I'll start immediately. Thanks.

$27 NZD 1 gün içinde

5,0

(148 değerlendirme)

6,4

@SiroosJafary

Good day, I am expert. I teach excel. I can say there is no formula in excel that I cannot handle it. I've got lots of experiences in excel automating and conditional formatting. I work with excel since 1999. Here are the links for my past experiences: https://www.freelancer.com/projects/Excel/Drawing-EXCEL.html https://www.freelancer.com/projects/4848189.html https://www.freelancer.com/projects/Visual-Basic-Excel/Excel-user-form.html https://www.freelancer.com/projects/Excel/Excel-Spreadsheet-Timecard-for-work.html https://www.freelancer.com/projects/Data-Entry-Excel/Excel-Line-Restructured.html Regards.

$28 NZD 1 gün içinde

5,0

(69 değerlendirme)

6,0

@dragos1910d

Hi, I am an expert in excel and vba. You can check my reviews. Contact me to start asap. Kind regards, Dragos!

$14 NZD 0 gün içinde

5,0

(85 değerlendirme)

5,8

@ethicalboy

Before everything when I want to download your files it says: The file you're looking for has been deleted or moved. Hello ready to start asap to deliver you, If you can give me your notes and conditions, I can deliver it to you fast, also about me: I am m.s of systems engineering and b.s of industrial engineering, and excel(dashboard, pivot tables, charts, conditions, conditional formatting, statistical, financial, mathematical, string, time, date,..functions) and vba expert. I have done similar projects and I am confident about my profession, I also accept revisions and removing errors and minor changes in future for free, whenever you are ready lets go. I have good command of English that I think can be useful for this project. I have a base of statistics, data analysis, mathematics, accounting, business analysis, cost calculating, project scheduling and project management and finance that helps in this project.

$30 NZD 1 gün içinde

4,9

(60 değerlendirme)

5,3

@adityasl

A proposal has not yet been provided

$28 NZD 1 gün içinde

5,0

(125 değerlendirme)

5,4

@JonNxt

Hi there, I've been working with Excel since before '98 and I've been using all possible versions of it. I have years of experience working with macros and writing code / debugging Excel VBA code. You may check my portfolio images to see few pieces of my kind of work. (This is what I do on daily basis). I am a professional and I can do a very good job. Also fast and accurate. Do not hesitate to contact me for further details. Kind Regards, Jon

$30 NZD 1 gün içinde

5,0

(34 değerlendirme)

4,9

@arpankumarde

Hi, I have worked on excel for 2.5 years in an I bank and analytic company. I am confident enough to handle your project with smoothness.I am good with number crunching. Looking forward to work with you. Thanks, Arpan

$14 NZD 1 gün içinde

4,9

(59 değerlendirme)

4,4

@dhiren707

I will be able to help with this. Please open chat session to discuss. I shall follow the steps as mentioned. Please share the dropbox links also.

$16 NZD 1 gün içinde

5,0

(15 değerlendirme)

3,8

@permana22sl

Dear, I'm serious person, I can do the task accurately and perfectly. I understood this project's requirements exactly. I am representing my bid as a core interest and available to further discussion. I am waiting for your reply to discuss further in this regard. Thanks

$30 NZD 1 gün içinde

4,7

(13 değerlendirme)

3,4

@skgtechnologies

Dear Client, I have gone through the project description and I would like to offer my services for the same. I have worked on several similar projects. I work as full time freelancer and have 11 years of experience in this field. I can reliably work on daily basis and perform the task as per your instructions. I am a tech savvy person and I remain online for almost 14 hours a day. I am reachable through skype, email or messengers. Please feel free to ask if you have any question. I assure you I'll perform upto your satisfaction if given a chance. Thanks Sachin Gupta

$25 NZD 1 gün içinde

5,0

(5 değerlendirme)

3,1

@sanjuchugh

Hi, How Are you doing? I am good in excel and I can do this job for you within 24 hours. Thanks, Sanjeev

$16 NZD 1 gün içinde

5,0

(3 değerlendirme)

1,3

@pritamkarwa

Hello Dear Sir, I assure of completing the job within stipulated time and with care and attention. I fully understood your job description. I'm really interested and ready to work as soon as possible. I hope you consider me as part of your staff. I'm a fast-learner, speed typist, flexible and dedicated. I am looking forward to your good response. More about Me: I am a Mechanical Engineer by Profession. I have just completed my graduation from MIT Pune University. I am well versed with all the MS Office tools. I Have a typing seed of 60WPM. I am dedicated towards my work. Providing a quality output towards end is my ultimate aim. I am a new bird in this sky of freelancing but i have come up with strong wings of dedication and smart work to fly high and stay long in this sky. I use internet on my laptop 8 hours a day. Do Consider. Thank You.

$14 NZD 1 gün içinde

5,0

(2 değerlendirme)

1,2

@B19

Hi. Im ready to help you. It just cost only 10$. I am ready to do this job as soon as possible at the minimum rate I am absolutely free. Best regard, Beknazar

$19 NZD 3 gün içinde

5,0

(2 değerlendirme)

1,0

@thesolvercompany

Hi, I am a merchandiser and i use excel advance formula in my routine work as you mentioned sumif, duplicate etc. I want to do this project so help me. Thanks.

$20 NZD 1 gün içinde

3,5

(1 değerlendirme)

0,6

@duobrains

Hello, I am expert in Excel and understand your requirements. I am interested in working on this job and will complete it today. Let me know in case of any question. Best Regards, Saghir

$30 NZD 1 gün içinde

0,0

(0 değerlendirme)

0,0

@deepakbhagat82

Please let me know the complete requirement of the project so that my skills could be of good value added to this project. I have an experience of 6 years working as data Entry specialist in Excel. My bid is also negotiable. Please let me know the good time to discuss to understand your project

$26 NZD 3 gün içinde

0,0

(0 değerlendirme)

0,0

@jeffcolaco

Hi, Highly motivated with strong operations acumen, work ethics, and desire to achieve professional growth and advancement through relevant experience. Equipped with extensive experience in Advising, Maintaining quality, management, research, development and problem solving. Jeff Colaco

$28 NZD 1 gün içinde