Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Urgently Need Help BIG TIME!!!!!!!!!

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Posts
    76
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    It's a simple query, but I really need it answered as I'm about to lose a LOAD of data!! Please help!!

    I have a worksheet that has a date column in it along with entries for that day. The thing is it won't sort correctly and I dont know how to fix it. When I sort the date column it does this:

    30/4/02
    30/4/02
    29/4/02
    29/4/02
    28/4/02
    3/5/02
    3/5/02
    2/5/02
    2/5/02
    1/5/02

    This is wrong. What I need it to do is sort so that the most recent date is near the top, like this:

    3/5/02
    3/5/02
    2/5/02
    1/5/02
    30/4/02
    29/4/02
    29/4/02

    and so on...

    it seems to be sorting it by the day number and not by the whole date and I dont know how to stop it! Can anyone help me, I am really in trouble here!!

    Janie

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Location
    Surrey, United Kingdom
    Posts
    75
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Buntykins,

    Hi, I just tried to recreate your problem but couldn't! I took the data from your post and entered it into a column. I then formatted the cells as a date and hit sort - descending. Worked fine. The only thing I can say is check you have the cells formatted as a date so that the sort recognises it as such.

    Nibbs

  3. #3
    Board Regular
    Join Date
    May 2002
    Location
    Ipswich, Suffolk, England
    Posts
    136
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Make sure that the data you are sorting in in date format, then when sorting use the decending / ascending as required

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Southfield,MI USA
    Posts
    2,312
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Bunty,

    If you're still having problems, then you may want to try the following:

    Type the number 0 in a cell somewhere, copy it, and then paste special/add it over your date range. You should be able to format the cell as a date and the column should then sort correctly.

    Hope that helps,
    Adam

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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