How do you work with drop down list to show a name, diff payment?
- From: "Drop down list" <Drop down list@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 30 Jun 2005 17:36:09 -0700
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)
.
- Follow-Ups:
- Prev by Date: Re: SUMIF
- Next by Date: Re: How do you work with drop down list to show a name, diff payment?
- Previous by thread: Re: Text in Formula bar displays vertical in Excel, How?
- Next by thread: Re: How do you work with drop down list to show a name, diff payment?
- Index(es):