Results 1 to 9 of 9

Create unique list based on date

Threaded View

  1. #1
    Registered User
    Join Date
    08-22-2014
    Location
    Bulgaria
    MS-Off Ver
    2010
    Posts
    6

    Create unique list based on date

    Hello!
    Sorry if there is topic like this, but i just didnt find any simple solution of my problem here.

    I have order list that i need to extract all unique names based on the date of the order.

    column A - date, fill with order dates
    column B - client, fill with rapeating client names
    E1 - citeria date
    G - the start of the result unique list
    I am using excel 2010

    How do i extract all Unique clients (column B) that made order after criteria date(E1)? The results lets say be plased from E2 and draged down depening of the number of results.
    example sheet example data.xlsx
    Last edited by solmyr; 08-22-2014 at 05:22 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] create a unique list based on a specific phrase
    By joannelittell in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-30-2013, 04:01 AM
  2. [SOLVED] Create list based on criteria and is unique
    By joannelittell in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-13-2013, 02:33 PM
  3. Replies: 7
    Last Post: 07-27-2013, 10:11 PM
  4. [SOLVED] Create unique list based on specific criteria
    By Joynesy in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-21-2013, 05:54 AM
  5. VBA: Create unique list based on latest entry in list
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-08-2011, 09:55 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