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

G

Guest

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
 
R

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting a string array containing combinations 4
Sumproduct and offset 4
how do i calculate 2' x 4' x 4" 5
Formatted cell column in drop down list 1
How to Link drop-down list? 2
To Link drop-down list 1
Help for formula. 6
Dependent drop down dynamic range formula, off sheet. 7

Top