Results 1 to 8 of 8

Need Distinct List Returned

Threaded View

  1. #1
    Registered User
    Join Date
    04-26-2016
    Location
    Los Angeles, CA
    MS-Off Ver
    2010
    Posts
    13

    Need Distinct List Returned

    Hi All,

    I am looking for a formula that will continually pull distinct values from a list based on the date information in an adjacent column.

    If the date in column C matches the date range in column A, I want all distinct values for column B to be listed in separate columns (W, X, Y...) based on their date.

    DistinctList.jpg


    DistinctList1.jpg


    I have already tried using Advanced Filter, but it won't continue to update as more information is inserted into the sheet.

    Please let me know if there are any questions.

    Your help is greatly appreciated!

    Thank you!
    Attached Files Attached Files
    Last edited by TRUCKING123; 05-31-2016 at 08:47 PM. Reason: Added Excel File

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] unique distinct list from a column but
    By pic2pic in forum Excel General
    Replies: 15
    Last Post: 02-02-2015, 05:15 PM
  2. List of distinct numbers withing range and another list extracted
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-16-2014, 03:27 PM
  3. Trying to average a distinct list
    By leftee96 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-07-2013, 04:36 PM
  4. [SOLVED] Distinct List from Column of Values
    By dianaschar in forum Excel General
    Replies: 4
    Last Post: 03-26-2013, 11:39 AM
  5. concatenating distinct list
    By youngbrianc in forum Excel General
    Replies: 4
    Last Post: 12-20-2010, 03:07 PM
  6. Distinct List
    By jerry8989 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-27-2007, 11:21 PM
  7. Distinct list formula
    By summergs in forum Excel General
    Replies: 5
    Last Post: 08-16-2006, 01:15 AM

Tags for this Thread

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