Re: Unique Dynamic Validated List

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Without using programming, you can right-click on a cell, and select Pick From List, and select a name from the dropdown list.

Or, using the keyboard, press Alt + the down arrow.

Jon C wrote: 
I have a column that will contain names. I'd like to use validation to make
sure that when a name is added it can be selected from a drop down assuming
the already appears in the column already. If not you can add a new name.

This works fine by defining a dynamic named range of the column as the
validation list. The problem however is that it doesn't give a unique list
i.e. the range is the whole of the column entered so far hence I get
multiple occurrences of the same name.

Does anyone know how I can make this a unique list? 

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.

Relevant Pages

  • Re: How to set condition for frequency?
    ... Dynamic Named Range: ... Refers to: ... Therefore, there are 7 items under the list, and the first task is to list ... for cell C1:C7, but one difficulty is that the length of list and the number ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Use a formula to define a range
    ... Dynamic named range: ... Create a name and type in the Refers To box: ... stored in a cell where B1 can be change if I want to look at a ... I would like to populate field of rows and columns depending upon data ...
    (microsoft.public.excel.misc)
  • External Reference with INDIRECT, INDEX/MATCH
    ... a dynamic named range. ... My users want to access data from this main source by selecting a range name ... from a list (cell with dropdown list). ... When I try to do this with INDIRECT I get the REF# error. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Sum Count of Two Numbers in the same Row
    ... > Dynamic Named Range "Results" spans 5 Columns and many Rows. ... > values using two cell references. ...
    (microsoft.public.excel.worksheet.functions)