What would be in the dropdown?

--

HTH

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


"Anthony Slater" wrote in message
...
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),"Sil ver",IF(AND(F23=500,F23<1
000),"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