Display data based on month

mole999

Well-known Member

Joined

Oct 23, 2004

Messages

10,524

Office Version

1. 2019
2. 2016
3. 2013

Platform

1. Windows

• Mar 16, 2014

• #2

if you add a helper that points at your date row then cell =text(date,"mmm")

 

Upvote 0

muhammad susanto

Well-known Member

Joined

Jan 8, 2013

Messages

2,077

Office Version

1. 365
2. 2021

Platform

1. Windows

• Mar 16, 2014

• #3

mole999, thanks, but my expected result is when i click/select month of February, the data show only February,,,

perhaps... the formula work like drop down list validation with month criterias (january, February, March, etc....up to December)..

how make it....

 

Upvote 0

mole999

Well-known Member

Joined

Oct 23, 2004

Messages

10,524

Office Version

1. 2019
2. 2016
3. 2013

Platform

1. Windows

• Mar 16, 2014

• #4

I thought you were going to place a filter over the cells, then you would just select the month of interest.

If I assume your table above "date" starts in A1 then in C2 =text(A2,"mmm") and drag down, then add filter to row 1

 

Upvote 0

Aladin Akyurek

MrExcel MVP

Joined

Feb 14, 2002

Messages

85,210

• Mar 16, 2014

• #5

E2: February, chosen from a drop list as you call it.

E4, control+shift+enter, not just enter, copy accross to F4, and down:

Rich (BB code):

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

 

Upvote 0

muhammad susanto

Well-known Member

Joined

Jan 8, 2013

Messages

2,077

Office Version

1. 365
2. 2021

Platform

1. Windows

• Mar 16, 2014

• #6

Aladin, i have do it your suggestion...but i don't show anything..

how your formula is work...

 

Upvote 0

mole999

Well-known Member

Joined

Oct 23, 2004

Messages

10,524

Office Version

1. 2019
2. 2016
3. 2013

Platform

1. Windows

• Mar 16, 2014

• #7

did you get the curly braces before and after aladins code

 

Upvote 0

Aladin Akyurek

MrExcel MVP

Joined

Feb 14, 2002

Messages

85,210

• Mar 16, 2014

• #8

muhammad susanto said:

Aladin, i have do it your suggestion...but i don't show anything..

how your formula is work...

Click to expand...

Control+shift+enter: Press down the control and the shift keys a the same time while you hit the enter key. When done properly, you see on the formula bar { and } around the formula.

 

Upvote 0

muhammad susanto

Well-known Member

Joined

Jan 8, 2013

Messages

2,077

Office Version

1. 365
2. 2021

Platform

1. Windows

• Mar 16, 2014

• #9

assuming in cell E2 contains month (January, February,etc) as drop down list....
i want when i click month of February or March, the data showing by each of date....

example ; on February
data showing ------06/02/2014----------ac


on March ;
data showing ------08/03/2014----------ad
------10/03/2014----------ae

etc..

 

Upvote 0

Peter_SSs

MrExcel MVP, Moderator

Joined

May 28, 2005

Messages

63,880

Office Version

1. 365

Platform

1. Windows

• Mar 16, 2014

• #10

muhammad susanto said:

Aladin, i have do it your suggestion...but i don't show anything..

how your formula is work...

Click to expand...

Aladin Akyurek said:

E2: February, chosen from a drop list as you call it.

E4, control+shift+enter, not just enter, copy accross to F4, and down:

Rich (BB code):

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

Click to expand...

I think Aladin's formula has a typo. Try changing that red 8 to a 2. Don't forget to re-enter with control+shift+enter before re-copying across and down.

 

Upvote 0