+ Reply to Thread
Results 1 to 1 of 1

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

  1. 06-03-2015, 01:33 PM #1
    suchetherrah
    suchetherrah is offline
    Forum Contributor
    Join Date
    05-22-2015
    Location
    Malaysia
    MS-Off Ver
    MS365
    Posts
    197

    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 With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to extract unique numbers from a list and sort them by date or age
    By enitron in forum Excel General
    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. [SOLVED] Dynamically extract unique records to a horizontal column header w/offset or index formula
    By DRogersJr. in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-09-2012, 09:16 AM
  5. Create a unique list from a list of duplicated dynamically?
    By Tommy1005 in forum Excel General
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1