Drop down
 

How do I create a unique dropdown from a list of values in another column
most of which occur more than once

Thanks in advance

Drop down
 

Do Data - Filter - Advanced Filter and select unique values. HTH Otto
"Raj" wrote in message
...
How do I create a unique dropdown from a list of values in another column
most of which occur more than once

Thanks in advance

Drop down
 

Thanks - But I think I did not clarify what I wanted properly

What I am trying to do is :

I have a Worksheet containing Product codes (appearing more than once) in
a column . There is data in other columns like time taken to manufacture,
Qty sold etc. Say there are 18 unique product codes but more than 300 rows
of data

In another sheet, I am trying to create a drop down box, using the Product
codes from sheet 1.


The drop down box shows the same product code appearing more than once. Can
I make each product code appear as a unique item - I want only the 18 product
codes to appear

Thanks / Raj



"Otto Moehrbach" wrote:

Do Data - Filter - Advanced Filter and select unique values. HTH Otto

Drop down
 

Follow Otto's suggestion then copy the unique product codes to another
sheet.

Give that range a defined name of MyList

In the source for your DV list enter =MYList


Gord Dibben MS Excel MVP

On Fri, 22 Aug 2008 14:48:15 -0700, Raj
wrote:

Thanks - But I think I did not clarify what I wanted properly

What I am trying to do is :

I have a Worksheet containing Product codes (appearing more than once) in
a column . There is data in other columns like time taken to manufacture,
Qty sold etc. Say there are 18 unique product codes but more than 300 rows
of data

In another sheet, I am trying to create a drop down box, using the Product
codes from sheet 1.


The drop down box shows the same product code appearing more than once. Can
I make each product code appear as a unique item - I want only the 18 product
codes to appear

Thanks / Raj



"Otto Moehrbach" wrote:

Do Data - Filter - Advanced Filter and select unique values. HTH Otto