LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,069
Default Data Validation /w Duplicate Entries

I have a rather large range that I am using to populate a validation list.
There are several duplicate entries. Is there some formula I can use that
will eliminate the duplicates in the drop-down menu on the validated cells?

Using Excel 2003

Thanks in advance!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Validation...I need to add more entries!! Davieslondon Excel Discussion (Misc queries) 4 November 25th 08 11:27 AM
how do I compare two data files for duplicate entries in Excel ghennessee Excel Worksheet Functions 2 December 17th 06 11:03 PM
How do I compare data from 2 worksheets to find duplicate entries Jack Excel Discussion (Misc queries) 2 August 16th 05 02:17 PM
Finding duplicate cell entries in a column of data Ellie Excel Discussion (Misc queries) 1 July 28th 05 01:41 PM
Using Data Validation - how do I allow other entries DianeMcP New Users to Excel 4 July 19th 05 05:51 PM


All times are GMT +1. The time now is 04:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"