Creating a dropdown list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
What would be in the dropdown?

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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
 
Back
Top