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

Hi

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

Roger Govier


"Mehboob Ellahi" <Mehboob wrote in message
...
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

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 wrote in message
...
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