No, you work with the data you already have, and adjust that formula to
point to the actual data.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Anthony" wrote in message
...
Thanks for helping.
So I cut and paste the job titles into the column. I then insert column
next to this and then insert the formula that you have provided?

"Bob Phillips" wrote:

Add a helper column to identify matches

=ISNUMBER(MATCH(A1,'Job Titles'!A1:A728,0))

and then do an advanced filter (dataFilterAdvanced Filter) on the TRUE
values from the help column

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Anthony" wrote in message
...
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?