Creating a dropdown list

[Anthony Slater]

Hi

I have a large amount of data that, according to certain values, is tagged
with a name such as 'Platinum, Gold, Silver and Bronze'.The data is as
follows: -

Col A: Client Number
Col B: Name
Col C: Value
Col D: "Platinum, Gold, Silver, Bronze"

Col D is
=IF(F23<100,"Bronze",IF(AND(F23>=100,F23<500),"Silver",IF(AND(F23>=500,F23<1000),"Gold","Platinum")))

The above is copied down a few thousand rows

However, the sheet is sorted by Client Number and so COL D is not in order

How can I create a drop-down list for each category on another sheet?

TIA

 

[Bob Phillips]

What would be in the dropdown?

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Anthony Slater]

Opps...

The drop downs would be "Platinum, gold, silver, bronze"

Then according to the category chosen, those particular clients would be
availble in a second drop down

 

[Bob Phillips]

aah! I would never have realised about the second dropdown from your post,
though I can see that it was alluded now I know <g>

There is a VBA solution that might help at
http://www.xldynamic.com/source/xld.Dropdowns.html

--

HTH

RP
(remove nothere from the email address if mailing direct)