Ditutup

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.

Kemahiran: Excel, Pemprosesan Data

Tentang Klien:
( 0 ulasan ) Eagle, United States

ID Projek: #33745077

116 pekerja bebas membida secara purata $34/jam untuk pekerjaan ini

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

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