Exclude matches in a list

  • Thread starter Thread starter David Stricklen
  • Start date Start date
D

David Stricklen

All,

I have a dynamic range list but there are many duplicates within 900+ entries. Is there anyway to prevent duplicates from showing in a dropdown?

David
 
hi, David !
I have a dynamic range list but there are many duplicates within 900+ entries.
Is there anyway to prevent duplicates from showing in a dropdown?
Click to expand...

AFAIK, if you don't want duplicate records in your dropdown list...
-> duplicate records *must* NOT be in your dropdown-source list

try with advanced filter, unique and copy to another location
-> and make the new location the source range for your dropdown list

hth,
hector.
 

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

Access Auto Matching Duplicates? 0
Help With MS Access 4
Frequency of items in a huge range 3
Duplicates 4
Duplicate Entries 4
Create value list from range 4
Show randomly a value from the list 1
How to extract duplicate records from 4 spreadsheets into a separate spreedsheet? 2

Back
Top