I am attempting to sort two columns of data, the first is a Date field (Week
Of), the other field is Numeric (Student ID). I am running Excel 2003 to sort
column A then column B, but the results only sort column A properly and leave
column B unsorted. When I sort just column B, the results are correct. Anyone
have any suggestions how I can resolve this problem?

Week Of ID
11/16/2009 0
11/16/2009 1
11/16/2009 95
11/16/2009 96
11/23/2009 282
11/30/2009 296
12/7/2009 78
12/7/2009 310
12/7/2009 152
12/7/2009 165
12/7/2009 122
12/14/2009 356
12/14/2009 360
12/14/2009 179
12/14/2009 317
12/14/2009 321
12/14/2009 341

Select the range (including both columns and the relevant rows) before you
ask Excel to sort.
Don't allow Excel to guess which rows & columns you want to sort.
--
David Biddulph

"Texins Karate" wrote in message
...
I am attempting to sort two columns of data, the first is a Date field
(Week
Of), the other field is Numeric (Student ID). I am running Excel 2003 to
sort
column A then column B, but the results only sort column A properly and
leave
column B unsorted. When I sort just column B, the results are correct.
Anyone
have any suggestions how I can resolve this problem?

Week Of ID
11/16/2009 0
11/16/2009 1
11/16/2009 95
11/16/2009 96
11/23/2009 282
11/30/2009 296
12/7/2009 78
12/7/2009 310
12/7/2009 152
12/7/2009 165
12/7/2009 122
12/14/2009 356
12/14/2009 360
12/14/2009 179
12/14/2009 317
12/14/2009 321
12/14/2009 341

Hi,
you have to highlight both columns at the same time and choose sort column A
and as a 2nd value sort column B

"Texins Karate" wrote:

I am attempting to sort two columns of data, the first is a Date field (Week
Of), the other field is Numeric (Student ID). I am running Excel 2003 to sort
column A then column B, but the results only sort column A properly and leave
column B unsorted. When I sort just column B, the results are correct. Anyone
have any suggestions how I can resolve this problem?

Week Of ID
11/16/2009 0
11/16/2009 1
11/16/2009 95
11/16/2009 96
11/23/2009 282
11/30/2009 296
12/7/2009 78
12/7/2009 310
12/7/2009 152
12/7/2009 165
12/7/2009 122
12/14/2009 356
12/14/2009 360
12/14/2009 179
12/14/2009 317
12/14/2009 321
12/14/2009 341