Filtering a list

J

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.
 
D

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.
 
A

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
 
Top