How do you work with drop down list to show a name, diff payment?

I create a drop down list already, but it shows repeated name in it.
For example,
Name price suppliers
a 1 haha
b 2 hihi
a 2 haha
c 2 hihi
b 3 hihi

What I want to do is to create a drop down list with the names, which when I
click on the drop down list "a", all the "a" rows in the list goes to the
top.
ie
Name price suppliers
a 1 haha
a 2 haha
b 2 hihi
c 2 hihi
b 3 hihi

also in the drop down list which I created, the "a" is repeated several
times, I would like to make a list with no repeated name, ie in the drop down
list only appears as (a b c) not (a b a c b)

I'm pretty sure this is what you want (courtesy Colo's Junk Room).
http://puremis.net/excel/code/021.shtml
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com



"Drop down list" <Drop down list@discussions.microsoft.com> wrote in message
news:DEAA2933-60C7-46C3-958F-18093B6578D9@microsoft.com...
> I create a drop down list already, but it shows repeated name in it.
> For example,
> Name price suppliers
> a 1 haha
> b 2 hihi
> a 2 haha
> c 2 hihi
> b 3 hihi
>
> What I want to do is to create a drop down list with the names, which when
I
> click on the drop down list "a", all the "a" rows in the list goes to the
> top.
> ie
> Name price suppliers
> a 1 haha
> a 2 haha
> b 2 hihi
> c 2 hihi
> b 3 hihi
>
> also in the drop down list which I created, the "a" is repeated several
> times, I would like to make a list with no repeated name, ie in the drop
down
> list only appears as (a b c) not (a b a c b)
>