+ Reply to Thread
Results 1 to 1 of 1

Extract Unique List fr specifc columns for all systems exclude spaces and sort dynamically

  1. #1
    Forum Contributor
    Join Date
    05-22-2015
    Location
    Malaysia
    MS-Off Ver
    2010
    Posts
    186

    Extract Unique List fr specifc columns for all systems exclude spaces and sort dynamically

    Hi, I know how to extract a unique list but not sure how to extract for specific columns. I am trying to extract, exclude spaces and sort a unique list from MasterDataEntry sheet with App Owner (Column 2) and Name (Column 3) for all systems. The unique list need to be extracted in Legend worksheet, column L.

    Attached is the sample data. Please assist to solve this issue? Thank you.
    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)

Similar Threads

  1. Replies: 8
    Last Post: 01-10-2014, 10:55 AM
  2. Extract unique value in list and sort the result
    By acerrhod in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-01-2013, 05:48 AM
  3. [SOLVED] Extract unique values from 2 columns DYNAMICALLY
    By albatr0n in forum Excel General
    Replies: 17
    Last Post: 08-28-2012, 08:42 AM
  4. Replies: 2
    Last Post: 08-09-2012, 09:16 AM
  5. Replies: 5
    Last Post: 01-12-2011, 08:49 AM

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