Count Occurances of Duplicate Vales in a Large Excel File

$30-250 USD

进行中

已发布

将近 13 年前

$30-250 USD

货到付款

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

项目 ID: 1094562

关于此项目

42提案

远程项目

活跃13 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

42威客以平均价$51 USD来参与此工作竞价

@greggfletcher

Hi, i can help.

$50 USD 在1天之内

5.0

(59条评论)

6.9

@binaryromel

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

$30 USD 在0天之内

4.8

(114条评论)

6.2

@liviakecskes

Hello! Please check PM!

$50 USD 在1天之内

5.0

(44条评论)

5.7

@gshiels

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

$80 USD 在1天之内

5.0

(11条评论)

5.1

@imudita

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

$30 USD 在2天之内

5.0

(27条评论)

4.8

@pyazlm

Refer to PMB.

$30 USD 在1天之内

4.8

(30条评论)

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 在3天之内

5.0

(12条评论)

3.7

@Dutchmatlab

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

$75 USD 在1天之内

4.9

(2条评论)

3.1

@kanadyanako

For your consideration.

$30 USD 在0天之内

4.0

(1条评论)

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 在1天之内

0.0

(0条评论)

0.0

@gnsdesigns

Ready to go when you are. See PM

$55 USD 在3天之内

0.0

(0条评论)

0.0

@vasuchoudhary

chk your pmb

$100 USD 在7天之内

0.0

(0条评论)

0.0

@Jr917

Immediately...

$30 USD 在15天之内

0.0

(0条评论)

0.0

@niranjanabc

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

$50 USD 在3天之内

0.0

(1条评论)

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 在2天之内

0.0

(0条评论)

0.0

@paridosika

kindly see pmb please.

$45 USD 在2天之内

0.0

(0条评论)

0.0

@tpraigama

I can do my best

$150 USD 在5天之内

0.0

(0条评论)

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 在1天之内