Filtering Columns to Align Matching Data

[Casino Guy]

If I have a list of data in column A, ie: phone numbers, and I also have a
list of similar data in column B.

Some, but not all numbers in column B match numbers in column A.

Is there a way to filter the two columns so that matching data from columns
A & B are aligned?

[R.VENKATARAMAN]

from what I understand vlookup function will be useful

--
remove $$$ from email addresss to send email

=========

"Casino Guy" <CasinoGuy@discussions.microsoft.com> wrote in message
news:E44C0A60-9FF8-4706-B46B-19C37371CD05@microsoft.com...
> If I have a list of data in column A, ie: phone numbers, and I also have
a
> list of similar data in column B.
>
> Some, but not all numbers in column B match numbers in column A.
>
> Is there a way to filter the two columns so that matching data from
columns
> A & B are aligned?
>
>

[Casino Guy]

R. Venkataraman

Thanks for your response but I don't know how to use the vlookup function
therefore I still haven't solved my problem.
Could you possibly create an example?



"R.VENKATARAMAN" wrote:

> from what I understand vlookup function will be useful
>
> --
> remove $$$ from email addresss to send email
>
> =========
>
> "Casino Guy" <CasinoGuy@discussions.microsoft.com> wrote in message
> news:E44C0A60-9FF8-4706-B46B-19C37371CD05@microsoft.com...
> > If I have a list of data in column A, ie: phone numbers, and I also have
> a
> > list of similar data in column B.
> >
> > Some, but not all numbers in column B match numbers in column A.
> >
> > Is there a way to filter the two columns so that matching data from
> columns
> > A & B are aligned?
> >
> >
>
>
>

[Max]

"Casino Guy" wrote:
> .. Could you possibly create an example ..

One play assuming I've read your underlying intent correctly ..

Assume col A contains the "master" list of numbers, and col B contains
another list to be checked against the master, data from row1 down, e.g.:

500 385
385 124
489 562
829 489
419 829
etc etc

Put in C1:
= IF(B1="","",IF(ISNUMBER(MATCH(B1,A:A,0)),ROW(),""))

Put in D1:
= IF(B1="","",IF(ISNUMBER(MATCH(B1,A:A,0)),"",ROW()))

Put in E1:
=IF(ISERROR(SMALL(C:C,ROWS($A$1:A1))),"",
INDEX($B:$B,MATCH(SMALL(C:C,ROWS($A$1:A1)),C:C,0)))

Copy E1 across to F1

Then just select C1:F1 and copy down
until the last row of data in col B

Col E returns all the numbers in col B found in col A
Col F returns all the numbers in col B not found in col A

(Results will be nicely bunched at the top in cols E & F)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

[Max]

For the sample data in the example,
you'd get in cols E & F:

385 124
489 562
829

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--