Display data based on month

[muhammad susanto]

hi all,..

i have data set this below start column a

date	title
02/01/2014	as
05/01/2014	ab
06/02/2014	ac
08/03/2014	ad
10/03/2014	ae
25/04/2014	af
etc...

<tbody>
</tbody>

i want to display data based on month...e.g. display data only February, etc..[with drop list month]

maybe,,something like Filter or helper column...

it's possible with formula (not pivot/vba)

thanks...

m.susanto

 

[Aladin Akyurek]

hi aladin, for reason certainly my boss need show all data in 1 year to count and analyze "shoot on target" in next year...

E4, control+shift+enter, not just enter, copy across, and down:

=IFERROR(INDEX(A$2:A$8,SMALL(IF(YEAR($A$2:$A$8)=YEAR(TODAY()),
    ROW($A$2:$A$8)-ROW($A$2)+1),ROWS(E$4:E4))),"")

Is this what is wanted?

 

[muhammad susanto]

thanks Aladin, but not i want..i mean, with your formula before how do show all data in 1 year (assuming the data in 1 year) & KEEP WITH DROP DOWN LIST CALL "ALL" as CONTROLLER , like drop down list month in cell E2 before....

perhaps, needed helper column??? thanks Aladin...

 

[Aladin Akyurek]

thanks Aladin, but not i want..i mean, with your formula before how do show all data in 1 year (assuming the data in 1 year) & KEEP WITH DROP DOWN LIST CALL "ALL" as CONTROLLER , like drop down list month in cell E2 before....

perhaps, needed helper column??? thanks Aladin...

E4, control+shift+enter, copy across, and down:

=IFERROR(INDEX(A$2:A$8,SMALL(IF(TEXT($A$2:$A$8,"mmmm")=
  IF($E$2="All",TEXT($A$2:$A$8,"mmmm"),$E$2),   
  ROW($A$2:$A$8)-ROW($A$2)+1),ROWS(E$4:E4))),"")

 

[muhammad susanto]

aladin, one word "AMAZING"

it's really 1.000.000% work....

are you man??

i am happy now...........[SOLVED]

 

[Aladin Akyurek]

aladin, one word "AMAZING"

it's really 1.000.000% work....

are you man??

i am happy now...........[SOLVED]

Great. Thanks for providing feedback.