Excel: to populate date properly under a month

[sarat]

Hello fnds,

In the attached excel sheet, how can I set the parameter so that date for a particular month will be displayed cumulatively.

If you check the date 21/12/2012, it should be comes under month ''DEC" in the filter button. But its displayed separtely in a single row.

How to resolve so that all dates will comes under their respective month.


Advance thanks

[Bob Phillips]

Select the whole column, and do a Data>Text To Columns on that column and just hit Finish.

[sarat]

Thanks Xld,
As you said, I did the same process but the issue is still there.

[Bob Phillips]

I did it on your file, and it fixed the problem nicely.

[sarat]

Hello Xld,
sorry to bother u once again.

If you have a look on the date for month Decemeber in the spreadsheet retrievd from database, then available dates available are 21/12/2012 11:58:35, 14/12/2012 10:28:29, 19/12/2012 8:54:46.



But when I select the month "Dec" through filter, only the date '7' is displayed (but not 21/12,14/12 and 19/12). Can I use any function so that all the dates will be populated under a particular month.

Thanks..

[david000]

But when I select the month "Dec" through filter, only the date '7' is displayed (but not 21/12,14/12 and 19/12). Can I use any function so that all the dates will be populated under a particular month.

I'm guessing that Excel doesn't filter by Month in that format. What you can do is use the text-to-columns delimiter option for "other" and type in "/" then separate the dates into their own columns; like 21 | 12 | 2012 that will allow you to sort by month. I opened your example and was able to do that no problem.