In Progress

Count Occurances of Duplicate Vales in a Large Excel File

I have 2 large data sets. Within each of them there is a field that contains street addresses. These addresses represent property owners. I need to sort the data so that I can find the property owners that own the most property. In a more technical sense, I need to sort the data according to the prevalence of recurring strings within a particular field of the data set. I want a new field in the data sets that counts the occurrences of the owners' address field so that i can sort the records according to. I would consider the data sets to be large, they are both more that 600000 records long and each record contains about 50 fields. I'm sure there is a very simple excel function that can handle this, I just don't know how to do it.

Thank you

Skills: Data Processing, Excel

See more: occurances, sort excel, simple excel, large data, excel function, excel duplicate, excel recurring, set technical data, excel contains, excel count, file sort, excel record, excel property, large file, duplicate file, record excel, contains function excel, street address excel, property excel, file handle, excel 2011, sort addresses, find duplicate file, excel large data, recurring excel

About the Employer:
( 1 review ) Bedford, United States

Project ID: #1094562

Awarded to:

bharanisrihari

Hello, Excel VBA expert here. Please check PM for details. Thanks!

$30 USD in 1 day
(57 Reviews)
6.3

44 freelancers are bidding on average $50 for this job

greggfletcher

Hi, i can help.

$50 USD in 1 day
(22 Reviews)
5.6
YourAssistant

{{(((Please read PM for further details)))}} …Thanks

$30 USD in 0 days
(52 Reviews)
5.6
gshiels

I have 20 years spreadsheet (Excel) experience and would appreciate the opportunity to do this project for you.

$80 USD in 1 day
(11 Reviews)
4.9
binaryromel

########## Excel expert here! Please check PM. ##########

$30 USD in 0 days
(37 Reviews)
5.0
imudita

It is easy as per you said, please see PM. I have sample of it.

$30 USD in 2 days
(26 Reviews)
4.6
pyazlm

Refer to PMB.

$30 USD in 1 day
(30 Reviews)
4.4
liviakecskes

Hello! Please check PM!

$50 USD in 1 day
(8 Reviews)
3.9
bluefox4ever

Dear bmiller4evr, I want to do this "Count Occurances of Duplicate Vales in a Large Excel File" project now, let's start immediately. I have read the job description. Please send me the excel files and more details More

$50 USD in 3 days
(12 Reviews)
3.8
Dutchmatlab

Can be done in excel or other software to generate compiled data.

$75 USD in 1 day
(1 Review)
2.8
kanadyanako

For your consideration.

$30 USD in 0 days
(1 Review)
1.8
ellentheisen

I could write an Excel macro to do this project.

$100 USD in 5 days
(0 Reviews)
0.0
Responser

Hi there - How are you today?

$30 USD in 1 day
(0 Reviews)
0.0
ColinParfitt

Hi, As you stated this is a fairly straightforward project, and as such can be completed by a competent Excel expert within 24 hours of receipt of the spreadsheet. I have experience of creating formula to analy More

$40 USD in 1 day
(0 Reviews)
0.0
rmjudkins

For the past decade my focus has been spreadsheet development within Excel utilizing VBA programming. Please refer to PM.

$50 USD in 1 day
(0 Reviews)
0.0
muzna88

check ur PM

$30 USD in 2 days
(0 Reviews)
0.0
shailaja0809

Please check your private message for details.

$40 USD in 1 day
(0 Reviews)
0.0
amin3754

Hi. I am a new free lancer. This is my first bid. The jobs looks simple. I do this kind of thing in my organization frequently. I work for a bank and there is a lot of customer data management just like yours. Thank More

$30 USD in 2 days
(0 Reviews)
0.0
joise86

LET ME DO ALL THE WORK FOR YOU :)

$30 USD in 2 days
(0 Reviews)
0.0
JaneGeisel

You're right. This is a fairly easy formula that can do all the calculations for you. However, it is dependent on the raw data being consistently entered.

$75 USD in 3 days
(0 Reviews)
0.0
hnmthu

I attached my solution for your requirement. please check my PM. Thanks.

$50 USD in 1 day
(0 Reviews)
0.0