Fermé

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.

Compétences : Excel, Traitement de Données

Concernant le client :
( 0 commentaires ) Eagle, United States

Nº du projet : #33745077

116 freelances font une offre moyenne de 34 $/heure pour ce travail

(252 Commentaires)
8.4
(283 Commentaires)
8.3
(457 Commentaires)
8.3
(1130 Commentaires)
8.4
(313 Commentaires)
8.1
(478 Commentaires)
7.7
(162 Commentaires)
7.8
(419 Commentaires)
7.6
(171 Commentaires)
7.8
(178 Commentaires)
7.8
(134 Commentaires)
7.9
(229 Commentaires)
7.5
(53 Commentaires)
7.2
(325 Commentaires)
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 Plus

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