Anthony,

Debra Dalgleish answered a similar post to this before so thanks to her for
this solution.

There are several methods of doing this but probably the best is to use an
Advanced Filter. Name the range that contains the criteria list (the 728
records). For example call it MyTitles.

For the criteria area, leave the heading cell blank, and in the cell
below, enter a formula that refers to the list of items, and the column
in the table that you want to check.

For example, if the column to check is column G, and the data starts in
row 2:

=COUNTIF(MyTitles,G2)<0

When you run the Advanced Filter, select both the blank heading cell,
and the cell with the formula, for the criteria range.

This will filter all those records that have a matching job title and hide
everything else. If you need this list separate, just tick the "Copy To
Another Location" option in the Advanced Filter dialog box.

Hope that helps.
DC


"Anthony" wrote:

I have a database of 8000 records. I have a second list of 728 job titles
which I have to extrapolate from the first list ie i only want the records
from the 8000 which match the job titles from the second list. What is the
best way to do this?