Filtering Columns to Align Matching Data

C

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?
 
C

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?
 
M

Max

Casino Guy said:
.. Could you possibly create an example ..
Click to expand...

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)
 
Top