+ Reply to Thread
Results 1 to 2 of 2

Retrieving List Values that Do Not Appear in a Second List

  1. #1
    JM
    Guest

    Great Array!

    This array worked perfectly for what I needed.
    Thanks!

  2. #2
    Forum Contributor
    Join Date
    12-07-2004
    Posts
    596

    Retrieving List Values that Do Not Appear in a Second List

    Problem:

    We want to create a new list consisting of the values from List1 (column A) that are not common to List2 (column B) as well.

    Solution:

    Use the INDEX, SMALL, IF, COUNTIF, and ROW functions as shown in the following Array formula:
    {=INDEX($A$2:$A$7,SMALL(IF(COUNTIF($B$2:$B$7,$A$2:$A$7)=0,ROW($A$2:$A$7),1000),ROW()-ROW($C$2)+1)-ROW($C$2)+1)}
    Enter the formula in cell C2 and copy it down the column until the #REF! error is returned.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1