If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sort problem
I have a 3 column table. Column one is locker number 1-300. Column 2 is
type M/Male F/Female and column 3 is key number. Column 1 has 300 lockers all M. Starting with entry 301 I start over again at 1 to reflect the start of W. When I sort column 1 I assumed the sort would result in 1m1w 2m2w 3m3w etc and down everyother one being a M or W all the way to the end filling 600 entries. That is not the case, as sorts into a non sensical mess moving everything down the table to the bottom......there are 800 spaces, therefore leaving the top 20 blank. Undoing the sort puts it all back. Any help here. Thanx Greg |
#2
|
|||
|
|||
Sort problem
Copy the first few rows of your table and post that. There must be something
odd about the way you've entered the numbers. Bear in mind that if the 'number' as you've entered it contains both digits and text, Word can't do a numeric sort, so you'll get an alphanumeric sort -- all the codes beginning with '1' (including 10s and 100s) -- then all the 2s (including 20s and 200s), etc wrote in message oups.com... I have a 3 column table. Column one is locker number 1-300. Column 2 is type M/Male F/Female and column 3 is key number. Column 1 has 300 lockers all M. Starting with entry 301 I start over again at 1 to reflect the start of W. When I sort column 1 I assumed the sort would result in 1m1w 2m2w 3m3w etc and down everyother one being a M or W all the way to the end filling 600 entries. That is not the case, as sorts into a non sensical mess moving everything down the table to the bottom......there are 800 spaces, therefore leaving the top 20 blank. Undoing the sort puts it all back. Any help here. Thanx Greg |
#3
|
|||
|
|||
Sort problem
I think its because one of the colums has both alpha and numeric
entries. Rather than post it I'd rather email it to you. Maybe you can take a look. Thanx much Greg |
#4
|
|||
|
|||
Sort problem
Sorry. No way I'll post my real email address on a public forum.
wrote in message ups.com... I think its because one of the colums has both alpha and numeric entries. Rather than post it I'd rather email it to you. Maybe you can take a look. Thanx much Greg |
#5
|
|||
|
|||
Sort problem
Whatever
|
#6
|
|||
|
|||
Sort problem
If you regularly post here with your real email address, you can end up with
thousands of SPAM messages drowning real messages in your mailbox and filtering doesn't get them all. wrote in message oups.com... Whatever |
#7
|
|||
|
|||
Sort problem
As greg210 is probably discovering for himself already.
"Charles Kenyon" wrote in message ... If you regularly post here with your real email address, you can end up with thousands of SPAM messages drowning real messages in your mailbox and filtering doesn't get them all. wrote in message oups.com... Whatever |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
sorting data on protected worksheet | Matt Sample | General Discussion | 5 | January 16th, 2006 08:49 PM |
Sort Preferences Problem | Chris | General Discussion | 2 | June 13th, 2005 02:39 AM |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
sort by date problem | scudooder | General Discussion | 6 | July 31st, 2004 12:56 AM |
Sort Problem | Wayne Burritt | Worksheet Functions | 1 | October 17th, 2003 08:41 PM |