Sorting Columns by Specific Values

Originally Posted by Tony Morgan

...I want to sort in two different ways....

If start locations are odd then I want the relevant rows to be sorted by the next column (the end location) in decending
order.

If they are even then I want the relevant rows to be sorted by the next column (the end location) in ascending
order.

Do you mean that you want to have two different sorts with two different sets of results, and you only use one at a time? Or that you want to sort a single time, but using different criteria for different rows?

In would be extremely helpful if you could show an example of the result that you are looking for based on the sample you attached. By the way screenshots are of very limited help here because we can't experiment with it or post a solution built into your own file.