comparing lists

  • Thread starter Thread starter brian
  • Start date Start date
B

brian

I have two lists with names and phone numbers. How can I search one list
against the other for all the matching records?
 
You can use conditional formatting to highlight colours in one list that
appear in the other:
Example:
If you want to match B1:B5 against A1:A5

You did not include your version number. These instruction apply to XL2003


Click on B1.
Click Format, Conditional Formatting
Change condition 1 to 'Formula is'
Enter the formula =MATCH(B1,$A$1:$A$5,0)>0
Click the format button
Choose your background colour
Click OK, twice
Copy B1
Highlight B1:B5
Click Edit, Paste Special, select Formats, click OK.

To highlight matching values in column A, do the reverse.

There is an alternate method that will do everything in one step but the
alternative will highlight two matching values in column one despite no
corresponding values in column 2.

For Excel 2007, the following shows how to add conditional formatting

http://www.homeandlearn.co.uk/excel2007/excel2007s6p2.html

The above Match formula should apply.
 
Back
Top