+ Reply to Thread
Results 1 to 11 of 11

How to compare two columns and find out the missing elements in one with respect to other

Hybrid View

  1. #1
    Registered User
    Join Date
    03-02-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    67

    Re: How to compare two columns and find out the missing elements in one with respect to ot

    Not sure of an easier method. I normally do in this manner.
    1) Keep the lists in two sheets with the same column names.
    2) Introduce a column "Available" by side of the first list
    3) Use Advanced Filter
    Range : Range of First List including the "Available" column
    Criteria : Second List
    4) Executing Advanced Filter will now display in first list items available in second list. Mark a flag in "Available" Column (Y)
    5) Clear the filter -> Create standard filter for list1 and filter "Available" Column for blanks.

    A Sample workbook attached for reference.
    Attached Files Attached Files

+ 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