Link to home
Start Free TrialLog in
Avatar of fireguy1125
fireguy1125

asked on

Excel 2010 Filtering Rows Based on Match List

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.

Thanks.
Avatar of Rgonzo1971
Rgonzo1971

HI,

Could you send a dummy example?

Regards
ASKER CERTIFIED SOLUTION
Avatar of Joe Howard
Joe Howard
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial