Wednesday, February 10, 2010

How to search items in a list against another list in Excel?

To search a list against another list follow these steps to find different values

1. Select the range or list which contains values to be compared
2. Click Format --> Conditional Format
3. Select Formula Is from drop down
4. Enter this formula COUNTIF($Range,$Cell), where $Range is the list which will be compared against and $Cell is the cell where list in #1 starts. i.e. $Range = $A1:$B2 and $Cell = C2
5. Click Format Style and select formatting such as pattern or font color.
6. Click Ok
7. Result will show cells with new formatting selected in last step.

No comments:

Post a Comment