Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
comparing lists
I have two lists with names and phone numbers. How can I search one list
against the other for all the matching records? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
comparing lists
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/excel2...l2007s6p2.html The above Match formula should apply. -- Steve "brian" wrote in message ... I have two lists with names and phone numbers. How can I search one list against the other for all the matching records? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
comparing lists
brian;337500 Wrote: 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 vlookup or Index/match to sort out the problem ....... but sample sheet will be more helpful to guide you properly -- mubashir aziz ------------------------------------------------------------------------ mubashir aziz's Profile: http://www.thecodecage.com/forumz/member.php?userid=237 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=94381 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing two lists | Excel Discussion (Misc queries) | |||
Comparing two lists | Excel Worksheet Functions | |||
Comparing Lists | Excel Worksheet Functions | |||
Comparing 2 Lists | Excel Discussion (Misc queries) | |||
Comparing two lists | New Users to Excel |