Select matching records from list
 

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?

Select matching records from list
 

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?

Select matching records from list
 

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?

Select matching records from list
 

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?