List Searcher

                             Search lists in Microsoft® Excel® with the List Searcher

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.

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.