Excel 2010 Filtering Rows Based on Match List
Posted on 2014-04-09
I have an Excel Workbook that contains 2 sheets.
Sheet1 contains 93 columns and 50,000 rows.
Sheet2 contains a single column (Names), with 2000 rows.
I want to filter the rows in Sheet1, by the Name column, based on the Names that are located in Sheet 2.
I would like to have Sheet1 filtered, so it contains all 93 columns of data, based on the 2000 names I have in Sheet2.
I've tried the Advanced filter in place, however this was unsuccessful.
My excel skill level is intermediate. I appreciate any help.
As some background information: Sheet 1 is an Outlook contacts list. Sheet 2 is a list of names that are located on Sheet1. I wish to have the sheet filtered to get all the values on Sheet 1, so I have 2000 rows of names and 93 columns.