Forum Discussion
need help on data extraction
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
1 Reply
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 email 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
