Find Jobs
Hire Freelancers

Identifying Duplicates in an Excel Spreadsheet

$30-250 USD

クローズ
投稿日: 7年以上前

$30-250 USD

完了時にお支払い
I have a list of records that I want to identify: 1. A change in field F when values in fields B and D repeat, and H remains same. 2. A change in field H when values in fields B and D repeat, and F remains same. 3. A change in field H and F when values in fields B and D repeat. 4. A change in field H and F when values in fields B and D are similar. 5. A change in field F when values in fields B and D are similar and field H remains same. We need to identify each of the instances. We need a count of each instance in each category, but do not include duplicates, i.e. if multiple records are identical but meet the criteria, it is only counted as one.
プロジェクト ID: 12160242

プロジェクトについて

55個の提案
リモートプロジェクト
アクティブ 7年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
この仕事に55人のフリーランサーが、平均$94 USDで入札しています
ユーザーアバター
Hi, I am good at Excel and vba. I have gone through the details. But, would like to discuss further to start working on the project. Looking forward to discuss in the chat.
$100 USD 1日以内
5.0 (768 レビュー)
7.8
7.8
ユーザーアバター
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$50 USD 1日以内
4.9 (281 レビュー)
7.6
7.6
ユーザーアバター
Hi, my name is Sevinc. I will write a vba code for you to perform the task... I read your "Identifying Duplicates in an 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 3日以内
4.9 (273 レビュー)
7.7
7.7
ユーザーアバター
Dear Sir/Ma'am, I am a Web research, Data Entry & Webs Scrapping expert. I checked and understood your requirements. I can handle this job very well to your appreciation. I can find and extract the information from different websites into an Excel sheet. I am ready to hear the details of the project more in detail now. I have always created a long-term collaboration with my clients through hard work and quality output for a reasonable price. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir
$150 USD 3日以内
4.9 (295 レビュー)
7.7
7.7
ユーザーアバター
Hello Dear, I am interested in your job post involving these skills. It says that you are looking for someone who knows English & MS Office, also who is a detail-oriented person. I think that I am the right person for the job. I have very good experience in Data Entry, Data Processing and making spreadsheet. As a data entry operator, I also am detail-oriented. Rest assured all the data will be accurately entered, no more, no less.
$100 USD 2日以内
5.0 (116 レビュー)
7.0
7.0
ユーザーアバター
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 1日以内
4.9 (280 レビュー)
7.2
7.2
ユーザーアバター
Dear Doclaw, I can start now to idenrtify duplicate on excel spreadsheet. I don't have any work for this time, so i can spend all my time. I have completed some excel project before, feel free to review my profile. Please give me the chance, i'm serious to work fast and accurate. Hopefully I can offer you my service and contribute to your success. Regards  Elta Marisa
$70 USD 1日以内
4.9 (240 レビュー)
6.8
6.8
ユーザーアバター
Hello, My name is Chris. As you can see from my profile, I have 16+ years experience working with Excel/VBA and 13 years teaching them both (all levels). I can certainly do excellent work with your project. There are a few points that need explanation, for example, if the order of records should remain as it is, or it is possible to sort them by any field (changing their order). Please contact me to further discuss the details. Looking forward to hear from you, Kind regards, Chris (chriskerpini)
$100 USD 2日以内
4.9 (72 レビュー)
6.7
6.7
ユーザーアバター
Hello sir, just saw your project description and you are looking for a freelancer to identity some data and change where needed and remove duplicate. I have experience working in this field for 3 years. So I am confident about completing this task perfectly. If you consider me then please open a chat session for further discussion. If you need I am willing to do a few samples. Here are some of my previous work experiences similar to this one - https://www.freelancer.com/jobs/project-6073246/ https://www.freelancer.com/jobs/project-7514235/ https://www.freelancer.com/projects/Web-Search/data-extractor-required-for-ongoing/ https://www.freelancer.com/projects/Data-entry.5767436/ https://www.freelancer.com/projects/Data-Entry-Excel/Data-entry-Automotive-parts-cataloue/
$150 USD 3日以内
4.9 (51 レビュー)
6.8
6.8
ユーザーアバター
Hello there! I would love to work on this project. I am a Qualified Chartered Accountant (CPA equivalent) with 5 years of experience in the field of accounts, auditing, taxation and financial management. I am currently pursuing CFA program, USA and have successfully completed Level 1. I have 8 years of rich experience in Microsoft Excel including working with financial modelling, dashboards and VBA. Please feel free to drop a message to discuss this project further. Best Regards, CA Raghav Bansal
$111 USD 3日以内
4.9 (97 レビュー)
6.6
6.6
ユーザーアバター
Hello. 30 % of employers hiring me once hired me again. I have experience in the same. I CAN do this job, and do it well!
$100 USD 3日以内
5.0 (117 レビュー)
6.5
6.5
ユーザーアバター
Greetings! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporting. In fact, over the last MONTH , I have spent at least 225 HOURS on automation in Excel. I can get your work completed to your fullest satisfaction. Looking forward to hearing a positive response from you. Thanks in advance! Have a Great Day! Srinivasan Krishnamoorthi
$45 USD 2日以内
5.0 (156 レビュー)
6.6
6.6
ユーザーアバター
Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. Please send me more details so that I can estimate cost and time better. I have completed more than 290 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$150 USD 3日以内
4.9 (124 レビュー)
6.3
6.3
ユーザーアバター
A proposal has not yet been provided
$80 USD 1日以内
5.0 (50 レビュー)
5.9
5.9
ユーザーアバター
Dear Hiring Manager, I have gone through your job posting and become very much interested to work with you. I am an expert in these fields. I have already completed several projects like this. For evidence you can see my profile. I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. -- Kinds Regards, Mehedi Hasan.
$144 USD 3日以内
4.8 (132 レビュー)
6.2
6.2
ユーザーアバター
Hello, I am proficient with Excel and VBA and I could write a script for this task. I have a lot of experience. Please contact me for more information.
$98 USD 2日以内
4.9 (126 レビュー)
5.7
5.7
ユーザーアバター
Hello there, how are you? I am interested in doing this project and can start working on it after being awarded. Hoping to hear from you and may you have a great day ahead. Thank you.
$155 USD 3日以内
4.9 (28 レビュー)
5.7
5.7
ユーザーアバター
Hello sir, Hope you are good today. I read your project and want to help you this project with my excellent skills and professional working experienced. I have completed many relevant projects in here. My special quality is 100% accuracy, timely delivered, and always available for communication. I am very first and reliable for this job and ready to do your lowest rate. I will be very happy sir if you ask me for sample work. Thanks.
$111 USD 3日以内
5.0 (24 レビュー)
5.5
5.5
ユーザーアバター
- This logic can be implemented finally showing up the counts for each category, excluding the duplicates. - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Excel macros - I have done complicated data processing using Excel macros for Exam sheet evaluation, (Recent)Circuit designing based on mulitple wire models, amps/voltages, calculations of taxes for Canadian citizen based on tax slabs per Fed and Provincial tax, based on the salary ranges etc. - Outlook macros - - Samples - Extracting mail contents parsing and sending to different customers, getting the task and calendar events from Outlook to Excel - Pl. review my portfolio on recent projects. My Skills: - I have good skills in Excel automation and used extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells,, data camparision using formulas, lookups and bringing up summaries. - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Outlook automation - Performing different actions - extracting, modifiying mails in Inbox, retrieving calendar, tasks or scheduling. - MS Access - Expert in designing table, user input forms and also reporting from data. - Excel to MS access data porting and conversion and designing new system for use.
$40 USD 1日以内
4.6 (49 レビュー)
6.1
6.1
ユーザーアバター
Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. with thanks and regards
$99 USD 3日以内
4.6 (52 レビュー)
5.8
5.8

クライアントについて

UNITED STATESのフラグ
Austin, United States
4.7
9
お支払い方法確認済み
メンバー登録日:2月 27, 2015

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。