Закрыт

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.

Навыки: Excel, Обработка данных

О клиенте:
( 0 отзыв(-а, -ов) ) Eagle, United States

ID проекта: #33745077

116 фрилансеров(-а) готовы выполнить эту работу в среднем за $34/час

(252 отзывов(-а))
8.4
(283 отзывов(-а))
8.3
(457 отзывов(-а))
8.3
(1130 отзывов(-а))
8.4
(313 отзывов(-а))
8.1
(478 отзывов(-а))
7.7
(162 отзывов(-а))
7.8
(419 отзывов(-а))
7.6
(171 отзывов(-а))
7.8
(178 отзывов(-а))
7.8
(134 отзывов(-а))
7.9
(229 отзывов(-а))
7.5
(53 отзывов(-а))
7.2
(325 отзывов(-а))
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 Больше

$25 USD / час
(243 отзывов(-а))
7.0
(133 отзывов(-а))
6.8
(172 отзывов(-а))
6.9
(167 отзывов(-а))
6.9
(227 отзывов(-а))
7.0
(18 отзывов(-а))
6.7