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.
(353 vote(s))
This article was helpful
This article was not helpful

Comments (0)
Post a new comment
Full Name:
Help Desk Software by Kayako Fusion