Consulting

Results 1 to 6 of 6

Thread: Excel: to populate date properly under a month

  1. #1
    VBAX Regular
    Joined
    Jun 2012
    Posts
    29
    Location

    Excel: to populate date properly under a month

    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
    Attached Files Attached Files

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    Select the whole column, and do a Data>Text To Columns on that column and just hit Finish.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    VBAX Regular
    Joined
    Jun 2012
    Posts
    29
    Location
    Thanks Xld,
    As you said, I did the same process but the issue is still there.

  4. #4
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    I did it on your file, and it fixed the problem nicely.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  5. #5
    VBAX Regular
    Joined
    Jun 2012
    Posts
    29
    Location
    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..

  6. #6
    VBAX Tutor david000's Avatar
    Joined
    Mar 2007
    Location
    Chicago
    Posts
    276
    Location
    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.
    "To a man with a hammer everything looks like a nail." - Mark Twain

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •