Printable View
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
Select the whole column, and do a Data>Text To Columns on that column and just hit Finish.
Thanks Xld,
As you said, I did the same process but the issue is still there.
I did it on your file, and it fixed the problem nicely.
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..
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.Quote:
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.