sorting range based on other column values in Excel 2010

Question

I have excel sheet contain data as below:

what we need is sorting range D2:E10 based on Column A values

we need result to be like this:

Is there any method allow us to do that?

(we recommend not to use macro if possible)

Answer 1

the closest solution with no macros is

select column a and d

use conditional fomat -> highlight cells Rules --> duplicated values

now all douplicted values cell color chaned

select range A2:B7 and custom sort using cell color, not colored cells at bottom

do the same with range D2:E10

hope this help you