how do i make a drop down list of selected names no repeatition

[Mehboob Ellahi]

I have a list of 6000 entries in excel of which 4 namely x1,x2,x3 and x4 are
used repeadily and i want to make a drop down list to make my search easier

[Roger Govier]

Hi

Try marking your range of header cells then
Data>Filter>Autofilter
Use the dropdown on the appropriate column to select X1 etc.
--
Regards

Roger Govier


"Mehboob Ellahi" <Mehboob Ellahi@discussions.microsoft.com> wrote in message
news:5FDE1119-620F-4632-BA15-AB66D0C66FF3@microsoft.com...
>I have a list of 6000 entries in excel of which 4 namely x1,x2,x3 and x4
>are
> used repeadily and i want to make a drop down list to make my search
> easier

[Otto Moehrbach]

If you are trying to find X1, X2, etc then Roger gave you a good way. But
from your subject line I gather that you want to make a list, from your
listing, that doesn't include any duplicates. Is that correct
Here are two methods for finding duplicates in a list:
Say you have a column of data that has some duplicate entries.
You want to find the duplicate entries.
Data is in column A starting at A1.
Formula in B1 is =If(Countif(A:A,A1)=1,True,False) Drag this to bottom of
table. Values appearing more than once appear as false. This can be modified
easily to show dups, triplicates etc.

And:
Format - Conditional Formatting
Formula is:
=COUNTIF(A:A,A1)>1
Set the format as you wish.

HTH Otto
"Mehboob Ellahi" <Mehboob Ellahi@discussions.microsoft.com> wrote in message
news:5FDE1119-620F-4632-BA15-AB66D0C66FF3@microsoft.com...
>I have a list of 6000 entries in excel of which 4 namely x1,x2,x3 and x4
>are
> used repeadily and i want to make a drop down list to make my search
> easier