[Solved]Sorting two arrays

Hi all!
I have two arrays that output as two columns next to each other. Like this:

ID	Responses
1	4
2	3
3	2
4	5
5	1

I would like to sort the responses column and have it show as this:

ID	Responses
4	5
1	4
2	3
3	2
5	1

I am guessing that I need to some how merge them into one array so I can sort them as one entity rather than sorting two columns separately.

Here is my sample data and the macro I use to pull the data i need for the two arrays. sample.xlsm

Thanks

Could try this? It would be pasted in your code after you place the data in taskA

Please Login or Register  to view this content.