Select matching records from list

A

Anthony

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?
 
B

Bob Phillips

Add a helper column to identify matches

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

and then do an advanced filter (data>Filter>Advanced 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)
 
A

Anthony

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?
 
B

Bob Phillips

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)
 
Top