Suljettu

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.

Taidot: Excel, Tietojenkäsittely

Tietoa asiakkaasta:
( 0 arvostelua ) Eagle, United States

Projektin tunnus: #33745077

116 freelanceria on tarjonnut keskimäärin $34/tunti tähän työhön

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

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