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

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

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" wrote:

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

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)


"Anthony Slater" wrote in message
...
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" wrote:

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