Aug 16 2018 12:13 PM
I have a 4000 record excel work sheet with names, business titles, and email, I need to extract all contacts with Human resource titles into a different worksheet with names, titles and email address
any help
Michael
Aug 16 2018 12:36 PM
Advanced filter..
make a copy of the worksheet so you have your original and a second one.
Imagine this is your 4k list and you wanted to copy all the administrative assistants somewhere..
Title | name | |
Account Executive. | Liam | Liam@email.com |
Administrative Assistant. | Noah | Noah@email.com |
Administrative Manager. | William | William@email.com |
Administrative Assistant. | James | James@email.com |
Create another table that looks like this:
Title |
Account Executive. |
This is your criteria
Now highlight the whole of your table including column headers (job title, name, phone number, email, whatever) and go to Data Ribbon, Sort and Filter, Advanced.
You will be asked for a list range, which should already be filled in, Criteria range which is the second table we made. Click ok and then it will filter the list for just those job titles in the criteria