Results 1 to 11 of 11

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

Threaded View

syedfahadjalali How to compare two columns... 03-07-2013, 01:03 PM
syedfahadjalali Re: How to compare two... 03-07-2013, 01:14 PM
tgsekhar Re: How to compare two... 03-07-2013, 01:20 PM
syedfahadjalali Re: How to compare two... 03-07-2013, 01:31 PM
tgsekhar Re: How to compare two... 03-08-2013, 10:46 PM
ChemistB Re: How to compare two... 03-07-2013, 01:31 PM
syedfahadjalali Re: How to compare two... 03-07-2013, 01:51 PM
syedfahadjalali Re: How to compare two... 03-07-2013, 01:54 PM
syedfahadjalali Re: How to compare two... 03-07-2013, 02:04 PM
ChemistB Re: How to compare two... 03-07-2013, 02:05 PM
syedfahadjalali Re: How to compare two... 03-07-2013, 02:11 PM
  1. #3
    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

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