How can I filter data based on items in a list?

Posted by user2964366 on Super User See other posts from Super User or by user2964366
Published on 2013-11-08T11:39:55Z Indexed on 2013/11/08 22:00 UTC
Read the original article Hit count: 266

Filed under:

microsoft-excel

|

Microsoft

|

filter

How can I filter entries containing any specific word in a list of words? For example, I have a list of road names in Singapore.

Amoy Street, Singapore
Ann Siang Hill
Anson Road
Arab Street
Armenian Street, Singapore
BBaghdad Street (Singapore)
Balestier Road
Banda Street
Bartley Road
Beach Road, Singapore
Bencoolen Street
Bernam Street
Boat Quay
Boon Tat Street
Boundary Road, Singapore
Bras Basah Road
Bugis Street
Bukit Batok Road
Bukit Pasoh Road
Bukit Timah Road
CCantonment Road, Singapore
Choa Chu Kang Road
Clarke Quay
Clementi Road
Club Street
Collyer Quay
Connaught Drive
Craig Road (Singapore)
Cross Street
and many more

My spreadsheet has a large number of entries like the following, which may or may not contain road names mentioned in my list:

Saw an accident at Thomson Road
Found this by accident
6 vehicles crashed at Balestier Road
I wanna crash now. So tired.
Bus collides with bicycle at Arab Street.
Accident at City Road.
You can crash my house later.

How do I filter to return entries that contains any road name identified in the list of names? How do I introduce an array/list of road names into Microsoft Excel and then relate it to a filter function?

© Super User or respective owner

Related posts about microsoft-excel

Connecting to Microsoft Excel using Oracle Data Integrator

as seen on Oracle Blogs - Search for 'Oracle Blogs'
The posts in this series assume that you have some level of familiarity with ODI. The concepts of Topology, Data Server, Physical and Logical Architecture are used here assuming that you understand them in the context of ODI. If you need more details on these elements, please refer to the ODI Tutorial… >>> More
Connect Microsoft Excel To SQL Azure Database

as seen on Dot net Slackers - Search for 'Dot net Slackers'
A number of people have found my post about getting started with SQL Azure pretty useful. But, it's all worthless if it doesn't add up to user value. Database are like potential energy in physics-it's a promise that something could be put in motion. Users actually making decisions based on analysis… >>> More
How to code Microsoft Excel "Shift Cells Up" feature in SQL

as seen on Stack Overflow - Search for 'Stack Overflow'
Take a simple table like below: Column Headings: || Agent's Name || Time Logged In || Center || Row 1: Andrew || 12:30 PM || Home Base Row 2: Jeff || 7:00 AM || Virtual Base Row 3: Ryan || 6:30 PM || Test Base Now lets say that a single cell is deleted so the table now looks like this: Column… >>> More
a question on using Microsoft Excel to do data analysis

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello everyone there, Me and my mates have been given an Excel spreasheet,which contains the data of the Census report. The column here corresponds to "Year" (from 2000-2010),the row means "City/Town",the cell is simply the population of a town at a particular year. We are up to doing some analysis… >>> More
Working with PivotTables in Excel

as seen on How to geek - Search for 'How to geek'
PivotTables are one of the most powerful features of Microsoft Excel. They allow large amounts of data to be analyzed and summarized in just a few mouse clicks. In this article, we explore PivotTables, understand what they are, and learn how to create and customize them. Note: This article… >>> More

Related posts about Microsoft

Microsoft Opens Up Silverlight for Windows Phone 7 Series - Microsoft News

as seen on Internet.com - Search for 'Internet.com'
In the latest Microsoft news, software giant announces Silverlight for multimedia Web development is now open source. Could the move spur a bevy of work for Silverlight developers and new apps for Microsoft's Windows Mobile 7 Series? >>> More
Lancement de la plateforme Microsoft Online Services : testez-la et venez en discuter avec Microsoft

as seen on Developper.com - Search for 'Developper.com'
[IMG]http://www.lgmorand.com/blog/image.axd?picture=2010%2f3%2fhome_header-bg+-+Copie.jpg[/IMG] Après le lancement de sa plateforme Azure en début d'année, Microsoft a lancé début mars sa nouvelle plateforme MOS, pour Microsoft Office Services, une plateforme d'outils de communication externalisés… >>> More
C# development with Mono and MonoDevelop

as seen on Developer IT - Search for 'Developer IT'
In the past two years, I have been developing .NET from my MacBook by running Windows XP into VM Ware and more recently into Virtual Box from OS X. This way, I could install Visual Studio and be able to work seamlessly. But, this way of working has a major down side: it kills the battery of my laptop…… >>> More
Differences Between NHibernate and Entity Framework

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Introduction NHibernate and Entity Framework are two of the most popular O/RM frameworks on the .NET world. Although they share some functionality, there are some aspects on which they are quite different. This post will describe this differences and will hopefully help you get started with the one… >>> More
How To Delete Top 100 Rows From SQL Server Tables

as seen on Tech Dreams - Search for 'Tech Dreams'
If you want to delete top 100/n records from an SQL Server table, it is very easy with the following query: DELETE FROM MyTable WHERE PK_Column IN( SELECT TOP 100 PK_Column FROM MyTable ORDER BY creation … >>> More