Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-02-2014, 05:08 PM
Balliol Balliol is offline Cannot get Sort to work. Windows XP Cannot get Sort to work. Office XP
Advanced Beginner
Cannot get Sort to work.
 
Join Date: Nov 2009
Posts: 73
Balliol is on a distinguished road
Default Cannot get Sort to work.

I am using word 2010 and have been trying to sort the table below with no success. Can you help?

02.08 1974 Oxfordshire County Council University grant result.
18.07.1977 University External Studies Teaching Course.
07.02.1977 University External Studies Teaching Course.
07.02.1977 6/2 stamp.
17.06.1976 Balliol Library lost books.
15.06.1976 Lukes, Montefiory and Newton-Smith defend their views on “The nature of explanation and the Concept of a Person.
11.06.1976 Balliol P.P.E. Tutors Schools dinner.
08.06.1976 Notes for a “Thanks to the Balliol Tutors at the end of our studies.
08.06.1976 Steven Lukes asks me to give “Thanks” few words at Schools Dinner.
20.05.1976 Party invitation.
13.05.1976 Discuss Graduate work?
04.05.1976 Balliol Battles account.
01.05.1976 Balliol library asking for their books back.
01.05.1976 Notes for Finals examination.
29.04.1976 Alan Fox note on revision.
25.4.1976 Revision time table.
23.12.1974 Oxfordshire County Council University grant receipts.
28.11.1974 Oxford Strumpet.
16.10.1974 Barclays Bank account.
1976 Examination answers paper.
1976 Finals papers questions.
1976 JCR Bill for Hilary term.
1976 Oxford Cyrenians asking for contributions of fifty pence.
1976 Oxford Union Society calendar.
1976 Oxford Union Treasurer note.
1976 University Labour Club internecine strife with dodgy accounts.


1974 Balliol JCR
23.061976 Revision note from Steven Lukes.
Reply With Quote
  #2  
Old 01-02-2014, 09:04 PM
macropod's Avatar
macropod macropod is offline Cannot get Sort to work. Windows 7 32bit Cannot get Sort to work. Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Aside from the fact your data as posted isn't a Word table, you cannot expect a Word table to sort something that appears to have such disparate data as '16.10.1974', '23.061976' and '1976' in date order. Neither '23.061976' nor '1976' is a date - they're just numbers. Similarly, a number sort will sort your dates as if they too are just numbers - in day, then month, then year, order.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 01-03-2014, 01:26 AM
Balliol Balliol is offline Cannot get Sort to work. Windows XP Cannot get Sort to work. Office XP
Advanced Beginner
Cannot get Sort to work.
 
Join Date: Nov 2009
Posts: 73
Balliol is on a distinguished road
Default

You stated, "Aside from the fact your data as posted isn't a Word table"
I used a Word 2010 page to build a table.
If that is not a Word Table could you please tell me what a word table is?

You stated that the following "is disparate data as '16.10.1974', '23.061976' and '1976' in date order. Neither '23.061976' nor '1976' is a date - they're just numbers."
They are dates in the format that is used in England so could you please tell how I could set them out so that dates or not they will be capable of sorting?

You state that, "Similarly, a number sort will sort your dates as if they too are just numbers - in day, then month, then year, order."
I'm not clear as to what is a number sort. Could you please elaborate?

I think that it is clear what I want to do from my first message could you please tell me how to do it?

Many thanks.
Reply With Quote
  #4  
Old 01-03-2014, 03:30 AM
macropod's Avatar
macropod macropod is offline Cannot get Sort to work. Windows 7 32bit Cannot get Sort to work. Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
I used a Word 2010 page to build a table.
If that is not a Word Table could you please tell me what a word table is?
If you have a look at your post, there is no table as such - just multiple lines of text. Whether what you have in your document is in a table - and what its structure might be - cannot be seen from that.
Quote:
They are dates in the format that is used in England so could you please tell how I could set them out so that dates or not they will be capable of sorting?
Since when is a '23.061976' date in any country? Similarly, '1976' is not a date - it is merely a number. You might interpret it as a date, but it could just as easily be a part number. To a computer, it's nothing more than a number.
Quote:
I'm not clear as to what is a number sort. Could you please elaborate?
To understand how a number sort works, visualize your dates as not having the periods. In such a scenario, a number sort for:
02.08.1974
23.12.1974
01.05.1976
11.06.1976
18.07.1977
would return the same as:
01051976
02081974
11061976
18071977
23121974
(note the re-ordering)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 01-03-2014, 04:24 AM
Balliol Balliol is offline Cannot get Sort to work. Windows XP Cannot get Sort to work. Office XP
Advanced Beginner
Cannot get Sort to work.
 
Join Date: Nov 2009
Posts: 73
Balliol is on a distinguished road
Default

It just goes to show that to understand computing one really should start at the beginning but so few of us do. I've grasped the idea but still have a little way to go but many thanks.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
EXCEL will not sort texascpa Excel 6 04-17-2013 07:58 AM
Cannot get Sort to work. Simple Excel sort did not work correctly Spideriffic Excel 1 09-06-2012 04:40 AM
Cannot get Sort to work. work vs regular work. and how regular work works user0044 Project 5 03-06-2012 07:28 AM
Cannot get Sort to work. Sort Data rkeles Excel 6 02-04-2012 01:31 PM
Sort Range boutells Excel 1 07-15-2009 03:02 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:56 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft