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
Bookmarks