Knowledgebase: Microsoft Excel
Retrieving Values that are Common to Two Lists
Posted by - NA - on 20 March 2006 08:45 AM
We want to create a new list consisting of the values that are common to both List1 (column A) and List2 (Column B).
Use the INDEX, SMALL, IF, COUNTIF, and ROW functions as shown in the following Array formula:
Enter the formula in cell D2 and copy it down the column until the #REF! error is returned.