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