Filtering data from one worksheet based on another

I need to display the rows in spreadsheet A based on whether a numerical
value in a particular column has the same value in a corresponding column of
spreadsheet B for example:

Spreadhseet A Spreadsheet B
1 2
3 3
5 6
6 7
7 8

The resulting filtered display should be

3
6
7

With all other data in the associated rows.

Thanks

I would use a helper column (new column A???).

Put formula like:
=isnumber(match(b2,sheet2!a:a,0))
(headers in Row 1)

Then apply data|filter|autofilter
filter to show True's


SKKB wrote:
>
> I need to display the rows in spreadsheet A based on whether a numerical
> value in a particular column has the same value in a corresponding column of
> spreadsheet B for example:
>
> Spreadhseet A Spreadsheet B
> 1 2
> 3 3
> 5 6
> 6 7
> 7 8
>
> The resulting filtered display should be
>
> 3
> 6
> 7
>
> With all other data in the associated rows.
>
> Thanks

--

Dave Peterson

Dave,
Your formula and approach made me look like a hero.

Thanks,
Suresh

"Dave Peterson" wrote:

> I would use a helper column (new column A???).
>
> Put formula like:
> =isnumber(match(b2,sheet2!a:a,0))
> (headers in Row 1)
>
> Then apply data|filter|autofilter
> filter to show True's
>
>
> SKKB wrote:
> >
> > I need to display the rows in spreadsheet A based on whether a numerical
> > value in a particular column has the same value in a corresponding column of
> > spreadsheet B for example:
> >
> > Spreadhseet A Spreadsheet B
> > 1 2
> > 3 3
> > 5 6
> > 6 7
> > 7 8
> >
> > The resulting filtered display should be
> >
> > 3
> > 6
> > 7
> >
> > With all other data in the associated rows.
> >
> > Thanks
>
> --
>
> Dave Peterson
>