I have a very large data base that has 10 columns and 160,000 rows of data. I want to be able to pull from this list all data that pertains to certain address ranges. As example the data base query would be something like this. Pull all data from street address and street names of 123 -450 Main Street; 455-623 XYZ Street; 777-1600 Anywhere Ave. Below are the type of columns in the data base.

Example

Column 1
Unique serial number
Column2
Code
Column 3
Description
Column 4
Date
Column 5
Time
Column 6
Street Address
Column 7
Street Name
Column 8
Apt #

The data pulled would look like this in a separate worksheet:

Serial # Code Description Date Time Address Street Name Apt #
125678 002 Rain Delay 12/14/14 10:00 611 Anywhere 102
888231 014 Sunshine 1/1/14 22:21 123 Main 172
8251236 016 Cancel 3/3/14 15:12 322 Main 235


etc, etc, etc,

Can this be done in Excel?