Sort Issue

T

Texins Karate

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
 
D

David Biddulph

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.
 
E

Eduardo

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top