List Searcher for Microsoft® Excel® 97, 2000, 2002, 2003, 2007, and 2010 Search and check a worksheet for matches to words or phrases in another list Color, mark, copy or delete matches Color or mark entries in a list that are NOT in another list Compare two ranges cell by cell to find differences

The List Searcher add-in for Microsoft Excel will quickly and easily search and check a worksheet list to see if it contains matches to words or phrases in a second list.  You can just have it color or mark (insert a phrase in a column) matching rows for follow-up.  Or, you can have it copy or delete matching rows.

If you would rather have the List Searcher identify the entries that do not contain matches to your words or phases it has options to do that.

The main dialog of the List Searcher looks like the following:

The first three options on the main dialog allow you to color or mark matching entries (with a cell entry in a column you specify), to copy the rows of matching entries, or to delete the rows.  The second three options allow you to do the same tasks of there is not a match. 

The last two options allow one to compare two ranges and find the differences. The first option is the most popular as it will identify entries in one range that are not anywhere in the second range.  The user can set the colors used to identify such cells. And, it automatically suggest doing the reverse search, IE, find cells in the second range that are not in the first range.

Users have used the List Searcher to find entries where survey responses need to be identified if the comments include the words "gold", "stock", or "bonds".  Other users have used it to check email addresses for domains they do not want to send emails to, for words like "spam", "bad", and "remove".

The List Searcher is menu driven for ease of use.  The List Searcher works by first having you identify the range to be searched.  One can either just select the top cell of the column to be searched, or select specific cells in a column:

Next, it asks if you want to specify a range of cells containing the words and phrases to be searched for, or to just type in a list.  Typing in a list is the easy way to do quick searches.  The following illustrates a typical user list (a small one):

If one wants to just type in a quick list, the following dialog is used:

Once the List Searcher has the range to be searched and the key words and phrases to be searched for, it will display a dialog of coloring and marking options if the user has selected an option to color and mark entries.  If the option to copy is selected, a dialog is presented for the user to specify the destination. In all options, a confirmation dialog to confirm the action is presented.  The List Searcher can search tens of thousands of entries in seconds.

To learn how to use the List Searcher, just click on the the "How to use" button on the main (first) dialog.  This will open a help and exercise file with step by step instructions.  And, if you need help, we are available 7 days a week.  Just call our phone number which is found at the top of every page.  We are located in the U.S. and enjoy talking to our customers.

Order online from our secure service. Get delivery in minutes!

US $49.95

Customers who viewed the List Searcher also viewed:

• Productivity Suite - Contains all of our add-ins including the Compare List Assistant.  Save $$
• Address Assistant - Easily split addresses in one cell into multiple cells. Fix zip codes needing leading zeros.
• CSV File Creator - Create CSV files the easy way, without Excel's warning messages.
• Data Cleaner - Eliminate tedious manual cleaning of data
• Duplicate Finder - Quickly find and remove duplicates in one list or between two lists.
• Multi-Column Sorter - Sort up to ten columns at once!
• Text File Importer - Import ASCII or text files with over a million lines!