+ Reply to Thread
Results 1 to 2 of 2

Sort List Removing Certain Values (formula)

  1. #1
    Registered User
    Join Date
    09-07-2011
    Location
    Sacramento
    MS-Off Ver
    Excel 2007
    Posts
    37

    Sort List Removing Certain Values (formula)

    I have two lists (columns) of data: a Full List of values, and an Exclusion List. I'd like a set of formulas that would create a third column Sorted List containing all the values in in the full list minus the values in the exclusion list. The attached spreadsheet shows what I am looking for.

    Note that the Full List and Exclusion List may have blanks at the end.

    The Full List MAY also have blanks within the data. I am not sure how much that complicates the formulas. So, I am looking at both solutions (one that can handle blanks within the data, and one that does not need to). Depending on the impact to the formulas, I can may choose one over the other and deal with the problem of blanks in a different way.

    Helper columns are fine.

    Thanks

    ExcludeList.xlsx

  2. #2
    Valued Forum Contributor
    Join Date
    02-12-2011
    Location
    The Netherlands
    MS-Off Ver
    365
    Posts
    818

    Re: Sort List Removing Certain Values (formula)

    In alphabetical order.
    Attached Files Attached Files
    Kind regards, Harry.

+ 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