Sorting Problem-Help!

[Guest]

How do I sort the following column

From this: to This

Status Due Date Status Due Dat
1 1/1/04 1 1/1/0
1 1/2/04 2 1/3/0
2 1/3/04 3 1/2/0
2 1/4/04 1 1/2/0
3 1/2/04 2 1/4/0
3 1/2/04 3 1/2/0

I would really appreciate the help
Jennifer

 

[AlfD]

Help!

Need more information.

1. Will there always be 1,2,3 in that order and no other values in co
3?

2. What are the rules for sorting? e.g. How do you choose one of th
status 1 's for the first trio and the other for the second? Is it th
first you meet going down the column?

3.Do the values of the dates have any bearing (looks unlikely) and i
so are they DD/MM/YY or MM/DD/YY?

Al

 

[jeff]

Hi,

Maybe add a 3rd column with a second qualifier for the
Status records, such as

a 1 1/01
b 1 1/02
a 2 ....
b 2 ....
a 3 ....
b 3 ....

then sort on col a, then b, then c.

jeff

 

[Guest]

The answer to question 1 is yes, there will just be 3 different values to choose from in that one column. It is a ranking based on the importance of the part

The rules for sorting are as follows, 1. grab the the ranking with the highest priorty "1" ranking and earliest due date, and then repeat right under that one with the second highest priority by finding the earliest due date with a "2" ranking, and finally followed by the "3" priority with the earliest due date, and then it just repeats this sorting all the way down the spreadsheet. I'm trying to spread out workload by having a high priority, with medium, with, low to give a nice workload balance. I hope this makes sense. The dates are important as due dates, of course you want the earliest due date first in a MM/DD/YY fashion. It gets a little more complicated then what I just said, I"m afraid some code will have to be written, and I am not knowledgeable on how to write code for this exercise. Can you help me

----- AlfD > wrote: ----

Help

Need more information

1. Will there always be 1,2,3 in that order and no other values in co
3

2. What are the rules for sorting? e.g. How do you choose one of th
status 1 's for the first trio and the other for the second? Is it th
first you meet going down the column?

3.Do the values of the dates have any bearing (looks unlikely) and i
so are they DD/MM/YY or MM/DD/YY

Al

 

[Dave Peterson]

This might work:

I assumed your data was in A2:B???.

I put this formula in C2 and copied down:

=COUNTIF($A$2:A2,A2)

My data then looked like:

Status Due Date count
1 01/01/2004 1
1 01/02/2004 2
2 01/03/2004 1
2 01/04/2004 2
3 01/02/2004 1
3 01/02/2004 2

I sorted it and got this:
Status Due Date count
1 01/01/2004 1
2 01/03/2004 1
3 01/02/2004 1
1 01/02/2004 2
2 01/04/2004 2
3 01/02/2004 2