Filtering Question

A

allanbugg

Hi,

I have a workbook with two sheets.

In Sheet 1, Column A there is a list of values approx. 524

In Sheet 2, Column B I have another list of values.

How do I filter to only show rows on sheet 2 if the value in column
appears in the list of values in column A on sheet 1?

Any help would be appreciated.

Thanks,

Allan Bug
 
S

Stefi

Hi Allan,
I would use a helper column in sheet 2, say C, insert
=IF(ISERROR(MATCH(B2,Sheet1!A:A,0)),0,MATCH(B2,Sheet1!A:A,0))

in C2, drag down to row 524, and filter column C >0!

Regards,
Stefi

„allanbugg†ezt írta:
 
D

Debra Dalgleish

Add the same heading at the top of both columns
Select a cell in the list on Sheet 2
Choose Data>Filter>Advanced Filter
Select Filter the list, in Place
For the List Range, select the list on sheet 2, including the heading
For the criteria range, select the list on Sheet 1, including the heading
Click OK
 
Top