How to sort this list?

Hi all,

i have some sorting issue here,

Below is the simple data i have with Three columns
Need to sort 3rd column from Highest to lowest, However the pair sets should not get disturbed in the first two columns

i have given expected output.

please help

Below Data

Amt D/c Num
125 D 58
125 C 56
40 D 43
40 C 44
56 D 65
56 C 64


Expected Output

Amt D/c Num
56 D 65
56 C 64
125 D 58
125 C 56
40 D 43
40 C 44

But if you do sort on the 3rd column you do get the results you say you expect

Apart from the last two results you show which I presume is a typo since you show the 43 number before the 44 number, i.e they are not sorted highest to lowest.

i didnt give best example earlier, consider below example of input and given expected Output too

conditions :
Last column should get sorted with highest to lowest
However the pairs of amt should , stay as paired. ( to keep them paired, last column sort can be adjusted that is fine)
Refer ouput for understanding

HTML Code: 

Hi,

The best you can do without a macro would be to have two sorts conditions in the same sort. The first usiing the first column and the second using the third column.

Your current requirement isn't possible since there is no order to the first column

post deleted.

Please try

Please Login or Register  to view this content.

Hi Jindon,

Your solution is giving out put as below, you are very close. Good part is firs column pairs are staying as paired, wherever they move.
only issue is the 3.26 pairs should move up considering the num is 64 order as highest.
and the 12 pairs should also move up considering the num is 53

HTML Code: 

Hi Bo, Ry,

result of your code is giving output as below,
You have nicely arranged the 3rd column Num, only thing is pairs should stick together in first column.

HTML Code: 

Try replace Sort_Array procedure with

Please Login or Register  to view this content.

Maybe try

Please Login or Register  to view this content.

Hi Jindon,

I tried with your current code, below is the data.
it doesnt seem to be giving expected result.


if you run through with below data, you can see....

HTML Code: 

Hi Jindon,

Thanks for your quick response.

correction is that the amt 31 and num with 64 should come at top right! as per highest to lowest in the third column
but yeah it should go as pairs

HTML Code: 

You are right, it will be always same amt with C and D.

Originally Posted by jindon

Still not clear though...

Please Login or Register  to view this content.

i am getting debug error on the below line.................

Please Login or Register  to view this content.

Originally Posted by jindon

If you upload the workbook that gives you the error, it will help.

Oh one intresting fact is, when i run with close to 15000 rows of data i am getting error.

But with less data like 20 rows, no issues works perfectly !