Closed

Database Manipulation - Real Estate Assessor Records

I have a large Excel spreadsheet containing more than 40,000 property records. The data fields include things like: property type (residential versus commercial), property subtype (condo, town house, etc.), property address, owner's mailing address, date of last sale, dollar value of last sale.

I want to be able to isolate clusters of records which have common characteristics using selection criteria. For example - residential properties, condos, most recent sale date within a given date range.

I want to be able to easily export each cluster so that I can analyze a given cluster and then create mailing labels for direct mail purposes.

Skills: Excel, Data Processing

About the Client:
( 0 reviews ) Eagle, United States

Project ID: #33745077

116 freelancers are bidding on average $34/hour for this job

(252 Reviews)
8.4
(283 Reviews)
8.3
(457 Reviews)
8.3
(1130 Reviews)
8.4
(313 Reviews)
8.1
(478 Reviews)
7.7
(162 Reviews)
7.8
(419 Reviews)
7.6
(171 Reviews)
7.8
(178 Reviews)
7.8
(134 Reviews)
7.9
(229 Reviews)
7.5
(53 Reviews)
7.2
(325 Reviews)
7.4
ksriniravi

Greetings! Here is a summary of solution that I envisage - 1) I would add an Analysis worksheet to existing workbook. 2) There would be different criteria to choose from in the analysis worksheet (to use your example More

$25 USD / hour
(243 Reviews)
7.0
(133 Reviews)
6.8
(172 Reviews)
6.9
(167 Reviews)
6.9
(227 Reviews)
7.0
(18 Reviews)
6.7