Removing Duplicates and sorting range as a 2d array

Hi there,

I am new to Excel VBA and I have to solve 2d array for linear interpolation. I have reach the point where I am selecting a range from the worksheet and checking for errors.

I have checked errors for non numeric, empty cells and removing duplicates but since it's a 2d array so I have to check for duplicates in second column but now I have to take this selected range and turn it into an array so that I can sort out the array in ascending/descending order.

For example:

Column 1 Column 2
2 12
9 17
11 21
2 15
7 15


As you can you See, this isn't in ascending order. Can someone please help me with this?

Thanks

Kind Regards