Level 2 Fire Restrictions in effect for western areas of Boulder County. No fireworks, fires, open flame, or shooting (see map and flyer).

Many County services are being offered online. Additionally, a variety of resources are available for those impacted by COVID-19.

Sorting Sales Data In Excel

Sorting Sales Data In Excel

Sorting Sales Data in Excel

  1. Chose a report for the property type and time frame of interest.
  2. Open the Excel file.
  3. To change the way the report is sorted, click in the upper left corner of the spreadsheet to select all records:
    Screenshot of a Spreadsheet
  4. Then select Data > Sort.
    Screenshot of a Spreadsheet
  5. You can sort by one, two, or three different fields.

Example 1: Find Only Properties in the Longmont Area:

  1. Sort by LOCCITY ascending
    Then by SALE_DATE ascending
    Then by ACCOUNTNO ascending
    Sort Window
    Sorting by LOCCITY will group all the Longmont properties together.
  2. Copy and paste the Longmont records to a new spreadsheet or delete the non-Longmont records.

Example 2: Find Only Sales of Double-wide Mobile Homes.

  1. Open up the residential file for the time frame of interest.
  2. Sort by BLDG_DESCRIPTION
    Then by DESIGN
    Sort Window
  3. Scroll down to “Manufactured Housing Improvement” group of records in the BLDG_DESCRIPTION field.
  4. Find the records with “DOUBLE WIDE” in the DESIGN field.
  5. Select the group of records that meet your criteria.
  6. Copy and paste them into a new document or print the selected records.
  7. See the list of sales report codes and descriptions.

Contact Us

Due to COVID-19, all Assessors Office sites are closed for business until further notice. Please call or email us with your questions during our normal business hours.

Assessor
Phone: 303-441-3530
Fax: 303-441-4996

Business Personal Property
Phone: 303-441-3316
Fax: 303-441-1783

Email

Schedule a meeting

Mailing Address
Main: PO Box 471
Boulder, CO 80306-0471

Locations
Boulder
1325 Pearl St., 2nd floor
Boulder, CO 80302
Map & Directions
Hours: 8 a.m.-4:30 p.m. M-F

Longmont
515 Coffman Street, Suite 114
Map & Directions

Lafayette
1376 Miners Dr., Unit 105
Map & Directions