vba - sorting range based on other column values in Excel 2010 -

i have excel sheet contain data below:

excel data

what need sorting range d2:e10 based on column values

we need result this:

requiredresult

is there method allow that?

(we recommend not use macro if possible)

the closest solution no macros is

select column , d

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

now douplicted values cell color chaned

select range a2:b7 , custom sort using cell color, not colored cells @ bottom

do same range d2:e10

hope you

Back