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<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