Data Validation List

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

How do you control what record shows up first when you
have a list in your validation statement? My drop down
goes to the end of the list....but I want it to start at
the top of the list. I use a named range... plus, I have
empty rows at the bottom in case the user wants to add
records and the list pics them up even though I tell it
not to pick up blanks. The blanks are in the named
range... please help !!!!
 
Hi

Use dynamic named range!
An example: You have a list in column A of sheet MyList, with header in cell
A1.
You define a dynamic named range MyList
MyList=OFFSET(MyList!$A$2,,,COUNTIF(MyList!$A:$A,"<>")-1,1)
and define a source for data validation list as
=MyList

NB! Whenever you use dynamic named range, you have to follow closely, that
your list doesn't have gaps.
 
Back
Top