Results 1 to 10 of 13

Thread: Delete List Contain Matching from Second List

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #6
    Senior Member
    Join Date
    Jun 2012
    Posts
    337
    Rep Power
    14
    here you go:

    list1: A10:A20
    list2: B10:B20

    Code:
    Sub tst()
        [A10:A20] = [if(countif(A10:A20,B10:B20)>0,"",A10:A20)]
    End Sub
    as an arrayformula:

    PHP Code:
    {=IF(COUNTIF(A10:A20;B10:B15)>0,"",A10:A20)} 
    Last edited by snb; 10-05-2012 at 12:48 AM.

Similar Threads

  1. Exclude Contents From List :
    By Rajan_Verma in forum Rajan Verma's Corner
    Replies: 16
    Last Post: 06-08-2013, 12:29 AM
  2. Get Random List :
    By Rajan_Verma in forum Rajan Verma's Corner
    Replies: 0
    Last Post: 06-06-2013, 07:53 PM
  3. Auto Unique List
    By r_know in forum Excel Help
    Replies: 8
    Last Post: 07-19-2012, 09:28 PM
  4. Create list with arrays
    By PcMax in forum Excel Help
    Replies: 2
    Last Post: 04-10-2012, 11:05 PM
  5. List Of All Files In A Folder
    By Excel Fox in forum Excel Help
    Replies: 2
    Last Post: 10-27-2011, 09:10 AM

Posting Permissions

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