Sorting in Excel

  scan513 17:16 17 Nov 03
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 03

Leave the cell blank (no text).

  velodrome 17:28 17 Nov 03

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 03

Snap!!!!!

  scan513 17:58 17 Nov 03

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 03

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 03

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 03

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

  scan513 19:09 17 Nov 03

Thanks everyone!!!

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

What is Amazon Go and will it come to the UK? The store without checkouts or queues

1995-2015: How technology has changed the world in 20 years

Why ecommerce hasn't taken off on social media

New MacBook Pro 2016 review | MacBook Pro with Touch Bar review: Apple's expensive and powerful…