[George Socha]

Steve,

Here is a more detailed explanation, with an attached spreadsheet to help illustrate what I mean.

Assume entries for five organizations. Four orgs have addresses which include states. One org has two addresses which include states. One org does not have any addresses. The entries look like this:

Org A   State A
Org B   State B, State A
Org D   State C
Org C   
Org E   State B

If ordered by Org only, the list should look like thise:

Org A   State A
Org B   State B, State A
Org C   
Org D   State C
Org E   State B

I would expect that if ordered by Org and then State, the list would look like this, which is what Excel does:

Org A   State A
Org B   State A, State B
Org C   
Org D   State C
Org E   State B

Instead, when ordered by Org and then State, the results are something like this, with the one Org that has no State at the end so that Org C comes after Org E even though C comes before B in the alphabet:

Org A   State A
Org B   State A, State B
Org D   State C
Org E   State B
Org C

I hope this explains better what I meant.

George

Attachments:

You must be logged in to view attached files.