Filtering a list

[Judicator]

Hello.

I have a list of 'N' number of names, phone numbers, addresses, which
looks like the following:

Serial Name Phone Address
------ ---- ----- -------
1 A 44656 Somewhere
2 B 41464 Someplace
3 C 65465 Nowhere

.. . . .
.. . . .
.. . . .

N NN 45646 Noplace


Now I need to single out some of the phone numbers and corre that
matches the serial numbers which I have put in another column. So,
how do I copy the entire rows that matches the phone numbers I have
placed in a separate column?

I don't know whether I am clear enough or not, but any help will be
much appreciated. Needless to mention, I am kind of newbie when it
comes to Excel.

Thank you for your help!

Btw, I am using Excel XP.

 

[Dave Peterson]

You could insert a help column and populate it with a formula like:

=isnumber(match(c2,sheet2!a:a,0))

If you see True, then it's a match. False means no match.

Then apply data|Filter|autofilter to that column. Filter on True and copy|paste
those visible cells whereever you want.

And your life will be easier if that other column of info is on another sheet.

 

[Debra Dalgleish]

You could use an Advanced Filter to extract the records. There are
instructions in Excel's Help files, and here:

http://www.contextures.com/xladvfilter01.html

Put the numbers in the criteria area, then select the worksheet on which
you want the results.
Start the advanced filter from there.

 

[Alan Beban]

If you want to make the functions in the freely downloadable file at
http://home.pacbell.net/beban available to your workbook, then if your
serial numbers were in N1:N20 you could array enter into O1:R1 and fill
down:

=ArrayRowFilter1(List,3,N1)

Alan Beban