Sorting in Excel

  scan513 17:16 17 Nov 2003
Locked

Hi,

I have five columns the third one contains the dates and I want to sort the whole thing by date, however one of the cells doesn't contain a date only text saying 'date unavailable yet'

How do I do it, when I go to 'Data' and 'Sort' and then pick the column I want it to sort by it totally messes up the whole page.

Does the text mess it up and why can't it just put this at the bottom?

Any help appreciated!

  VoG II 17:20 17 Nov 2003

Leave the cell blank (no text).

  velodrome 17:28 17 Nov 2003

Leave the cell blank and that entry should appear at the bottom of the list.
If you haven't got a header row make sure that the "no header row" is ticked

  velodrome 17:29 17 Nov 2003

Snap!!!!!

  scan513 17:58 17 Nov 2003

Ok, I removed the text and then did the sort but now it just sorts by the 1st number in the date

eg 15.12.2003
15.12.2003
20.01.2004
20.11.2003
21.11.2003
25.11.2003

how do I get it to sort by the whole date?

  Jester2K II 18:00 17 Nov 2003

Have you told it this is a date field or just a text field. If its a text field it'll sort as you shown, if you format the fields as dates then it should sort properly.

Right click the cells, Format Cells..., Select a Date format

  scan513 18:28 17 Nov 2003

Cheers, now thats working!

Just one more question, the details I'm trying to sort take up two rows, whereas the date corresponding to these details only take up one row.

so now excel (Me) just sorts the date row and one line of detail, and the extra rows of detail are relagated to the bottom of the page.

How do I get it to recognise both rows of detail, sorry about all the questions but I'm completely lost here!

  VoG II 18:32 17 Nov 2003

You'll have to duplicate the date in both rows.

  scan513 19:09 17 Nov 2003

Thanks everyone!!!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

See the work of famous artists playing with toys

iPad Pro 10.5in (2017) review

Comment faire une capture d’écran sur un Mac ?