+ Reply to Thread
Results 1 to 8 of 8

How to extract unique value within a specific period of time

  1. #1
    Registered User
    Join Date
    08-11-2013
    Location
    Jakarta
    MS-Off Ver
    Excel 2007
    Posts
    4

    How to extract unique value within a specific period of time

    Let's say I need to extract values in Column B (NAME) and put it in Column D.
    I just want to extract the NAME which exist within the Month. For example "Mar-14"
    Would appreciate if someone can help with the Formula for D.
    (I put the results in Column D, but off course manually).

    A B C D
    Mar-14
    DATE NAME NAME
    5-Feb-14 PEGASUS PEGASUS
    6-Feb-14 PEGASUS LIBERTY
    7-Feb-14 PEGASUS TIBERIAS
    8-Feb-14 LIBERTY JAVA
    9-Feb-14 LIBERTY PENGUIN
    10-Feb-14 LIBERTY
    11-Feb-14 LIBERTY
    12-Feb-14 SENTINEL
    13-Feb-14 SENTINEL
    14-Feb-14 SENTINEL
    15-Feb-14 SENTINEL
    1-Mar-14 PEGASUS
    2-Mar-14 PEGASUS
    3-Mar-14 PEGASUS
    4-Mar-14 PEGASUS
    5-Mar-14 LIBERTY
    6-Mar-14 LIBERTY
    7-Mar-14 PEGASUS
    8-Mar-14 PEGASUS
    9-Mar-14 PEGASUS
    10-Mar-14 LIBERTY
    11-Mar-14 TIBERIAS
    12-Mar-14 TIBERIAS
    13-Mar-14 TIBERIAS
    14-Mar-14 TIBERIAS
    15-Mar-14 TIBERIAS
    16-Mar-14 TIBERIAS
    17-Mar-14 TIBERIAS
    18-Mar-14 JAVA
    19-Mar-14 JAVA
    20-Mar-14 JAVA
    21-Mar-14 JAVA
    22-Mar-14 JAVA
    23-Mar-14 PENGUIN
    24-Mar-14 PENGUIN
    25-Mar-14 PENGUIN
    26-Mar-14 PENGUIN
    27-Mar-14 PENGUIN
    28-Mar-14 PENGUIN
    29-Mar-14 PENGUIN
    30-Mar-14 PENGUIN
    31-Mar-14 PENGUIN
    1-Apr-14 SENTINEL
    2-Apr-14 SENTINEL
    3-Apr-14 SENTINEL
    4-Apr-14 SENTINEL
    5-Apr-14 TIBERIAS
    6-Apr-14 TIBERIAS
    7-Apr-14 TIBERIAS
    8-Apr-14 TIBERIAS

    Thanks,
    DAR.K

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,405

    Re: How to extract unique value within a specific period of time

    Add filter to first row and filter out desired month or date

  3. #3
    Registered User
    Join Date
    08-11-2013
    Location
    Jakarta
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: How to extract unique value within a specific period of time

    Thanks for the Idea, But I'm afraid that's not what I look for.
    I'm interested in using an Index/Match formula, in case I need to place the results in a different sheet.

  4. #4
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,405

    Re: How to extract unique value within a specific period of time

    Try this with aditional column:
    Attached Files Attached Files

  5. #5
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: How to extract unique value within a specific period of time

    Please see attached file with one formula in Column D.
    Attached Files Attached Files
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  6. #6
    Registered User
    Join Date
    08-11-2013
    Location
    Jakarta
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: How to extract unique value within a specific period of time

    Wow... I didn't expect such a complicated formula.
    But anyway, thank you zbor for your thought.

  7. #7
    Registered User
    Join Date
    08-11-2013
    Location
    Jakarta
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: How to extract unique value within a specific period of time

    Excellent Alkey,
    Thanks a lot.

  8. #8
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: How to extract unique value within a specific period of time

    You're welcome and thank you for the feedback!

    Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).

+ 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. [SOLVED] Counting unique clients during a specific period of time with other criteria
    By dkstew in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-30-2012, 12:17 PM
  2. Replies: 11
    Last Post: 05-20-2011, 02:09 PM
  3. Specific time period calculation from a time range
    By Khaldon in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-18-2011, 06:44 AM
  4. Replies: 2
    Last Post: 04-27-2011, 08:21 AM
  5. counting unique entries for a specific date period in a series of dates
    By woody382 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-16-2010, 01:57 PM

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