# How to extract unique value within a specific period of time

1. ## 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. ## 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. ## 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.

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

Please see attached file with one formula in Column D.

6. ## 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. ## Re: How to extract unique value within a specific period of time

Excellent Alkey,
Thanks a lot.

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

You're welcome and thank you for the feedback!

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

#### 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