sorting help

[lwilt]

I'm trying to sort this data so that Q ends up in descending order. Currently you can see it's not at AY521.

skusku1QP
AF121C60AF121C60
AK18025AK1802569
AK18025128.5
AK18025248
AK18025367.25
AB411FIRAB411FIR354
AB411FIR652
AB411FIR1250
AB411FIR2448
AE120AUSAE120AUS360
AE120AUS656.25
AE120AUS1253.13
AE120AUS2450
AY521AY52115156
AY5219159
AY5216162
AY5213165
AY521
AY521
AY521
AY521
AY521
AY521
AY521
AY521
AY521
AY521
AY521
AY522AY5223183.5
AY5226179
AY5229169
AY52215163
AY522
AY522
AY522

How should I sort the 4 columns so that columns A and B look basically the same but it puts column c in descending order?

 

[lwilt]

uploading the file should make it easier to see

 

[David Evans]

Well I took a quick look at it between my own work projects here. I think I understand your question ....
I used the data on Sheet 1 of the worksheet you provided.
I first inserted a table - "Insert-Table" then sorted on Q. However, I think your data may need reviewing - you appear to have a lot of duplicates, which *can* be problematic in most cases ...

Oh! and are we talking shoes?!