Identifying Duplicates in an Excel Spreadsheet

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.

Skills: Data Processing, Excel

See more: excel combine lists duplicates, excel vba find duplicates, excel select highest duplicates, excel macro highlight duplicates, merge excel sheets remove duplicates, merge excel spreadsheets find duplicates, merge excel spreadsheets delete duplicates, merge excel sheets delete duplicates, example weighted criteria spreadsheet excel, bowling tournament spreadsheet excel, copying pasting excel spreadsheet excel spreadsheet, bank statement spreadsheet excel, copy paste spreadsheet excel websites, merging excel duplicates, copy excel spreadsheet excel spreadsheet, merge files excel duplicates, copy pdf spreadsheet excel, copy spreadsheet excel, evaluation spreadsheet excel, merge excel files delete duplicates, copy browser spreadsheet excel code, putting existing spreadsheet excel, merge excel documents delete duplicates, word spreadsheet excel, project status spreadsheet excel chart

About the Employer:
( 9 reviews ) Austin, United States

Project ID: #12160242

57 freelancers are bidding on average $93 for this job

$150 USD in 2 days
(361 Reviews)
$100 USD in 1 day
(248 Reviews)

Hello there, We are interested in offering following of our excel related services listed below: 1. Usage of ASAP Utilities. 2. Usage of conditional formatting. 3. Usage of in-built and custom formulas and func More

$30 USD in 1 day
(108 Reviews)

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 More

$100 USD in 3 days
(196 Reviews)

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 in 1 day
(296 Reviews)

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

$150 USD in 3 days
(50 Reviews)

Hello, I am ready to start work with you. Please provide me detail of your task. LET'S DISCUSS before starting the task. I would love to work on this task. I can easily do any task in excel for example, creat More

$157 USD in 3 days
(117 Reviews)

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

$111 USD in 3 days
(82 Reviews)

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. Ple More

$70 USD in 1 day
(129 Reviews)

Hello sir,we have 8 member team and we can start the work right now just check my review u can see and u never disappointed with my work quality,delivery and price. Awaiting your [login to view URL]

$55 USD in 1 day
(238 Reviews)

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 More

$150 USD in 3 days
(132 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 1 day
(118 Reviews)

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

$100 USD in 2 days
(54 Reviews)

I have read your project description clearly and agree that we can complete tasks with high quality and [login to view URL] our reviews to confirm our work quality(100%completion rate).We are very responsible towards our More

$35 USD in 1 day
(116 Reviews)

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 More

$144 USD in 3 days
(117 Reviews)

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. Plea More

$150 USD in 3 days
(103 Reviews)
$83 USD in 1 day
(118 Reviews)

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 in 3 days
(75 Reviews)
$125 USD in 7 days
(36 Reviews)

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

$50 USD in 1 day
(69 Reviews)