Count Occurances of Duplicate Vales in a Large Excel File

$30-250 USD

W trakcie realizacji

Opublikowano

prawie 13 lat temu

$30-250 USD

Płatne przy odbiorze

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

Data Processing

Excel

Identyfikator projektu: 1094562

Informację o projekcie

42 ofert

Zdalny projekt

Aktywny 13 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Adres e-mail

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe

Otrzymuj wynagrodzenie za swoją pracę

Przedstaw swoją propozycję

Rejestracja i składanie ofert jest bezpłatne

42 freelancerzy składają oferty o średniej wysokości $51 USD dla tej pracy

@greggfletcher

Hi, i can help.

$50 USD w 1 dzień

5,0

(59 opinii)

6,9

@binaryromel

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

$30 USD w 0 dzień

4,8

(114 opinii)

6,2

@liviakecskes

Hello! Please check PM!

$50 USD w 1 dzień

5,0

(44 opinii)

5,7

@gshiels

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

$80 USD w 1 dzień

5,0

(11 opinii)

5,1

@imudita

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

$30 USD w 2 dni

5,0

(27 opinii)

4,8

@pyazlm

Refer to PMB.

$30 USD w 1 dzień

4,8

(30 opinii)

4,4

@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 of the job. Regards, Oliver

$50 USD w 3 dni

5,0

(12 opinii)

3,7

@Dutchmatlab

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

$75 USD w 1 dzień

4,9

(2 opinii)

3,1

@kanadyanako

For your consideration.

$30 USD w 0 dzień

4,0

(1 opinia)

1,5

@tpanarese

Hello, I am a very experienced analyst with advanced excel function and visual basic knowledge. I can turn this around for you very quickly. I would appreciate the opportunity to assist you in your task. Thank you for your consideration.

$30 USD w 1 dzień

0,0

(0 opinii)

0,0

@gnsdesigns

Ready to go when you are. See PM

$55 USD w 3 dni

0,0

(0 opinii)

0,0

@vasuchoudhary

chk your pmb

$100 USD w 7 dni

0,0

(0 opinii)

0,0

@Jr917

Immediately...

$30 USD w 15 dni

0,0

(0 opinii)

0,0

@niranjanabc

Provide me a sample work so I can bid orioerly . That will be heipful for both of us. Niranjana

$50 USD w 3 dni

0,0

(1 opinia)

0,0

@asankapradeep

Dear Hiring Manager, I'm a Data Entry Operator with experience in Data Entry work Projects, and I'm very interested in your job post involving these skills. my responsibilities included data entry & data verification & web research. My experience entering data to the software with speed & accuracy (42 wpm & 96%). I am an expert in data entry & MS office & web research .I believe my skills would be ideal for your project. I am available to chat by email or Skype, and would be happy to set up a convenient time to discuss the application you're moving and some ideas about the safest way to get it into the cloud. Thank You. Regards, Asanka.

$30 USD w 2 dni

0,0

(0 opinii)

0,0

@paridosika

kindly see pmb please.

$45 USD w 2 dni

0,0

(0 opinii)

0,0

@tpraigama

I can do my best

$150 USD w 5 dni

0,0

(0 opinii)

0,0

@abuch

I have done many reports starting with large data files like this at the Fortune 500 company where I work. I provide quality work, beating financial and time budgets. My current Excel project is saving the company ~$50k compared to outsourcing. I look forward to working with you to create a solution using formulas and VBA. The first step is to sit down and go through the details.

$50 USD w 1 dzień