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 b
appears in the list of values in column A on sheet 1?

Any help would be appreciated.

Thanks,

Allan Bugg


--
allanbugg
------------------------------------------------------------------------
allanbugg's Profile: http://www.excelforum.com/member.php...o&userid=35847
View this thread: http://www.excelforum.com/showthread...hreadid=556383

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,She et1!A:A,0))

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

Regards,
Stefi

€žallanbugg€� ezt Ã*rta:


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 b
appears in the list of values in column A on sheet 1?

Any help would be appreciated.

Thanks,

Allan Bugg


--
allanbugg
------------------------------------------------------------------------
allanbugg's Profile: http://www.excelforum.com/member.php...o&userid=35847
View this thread: http://www.excelforum.com/showthread...hreadid=556383

Add the same heading at the top of both columns
Select a cell in the list on Sheet 2
Choose DataFilterAdvanced 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

allanbugg wrote:
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 b
appears in the list of values in column A on sheet 1?

Any help would be appreciated.

Thanks,

Allan Bugg




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html