Data validation list shows what's at the bottom and not the

[dee101]

I am using a name range as a list for the data validation, name range is
=OFFSET(Names!$C$2,0,0,COUNTA(Names!$C:$C),1) , this works to give me the names in the range, but when I click on the drop down arrow the list shows up form the bottom to the top, if I want to pick a name from the top of the list I have to scroll up to it, is there any way to make the data validation list show what is in the top of the list?

Say I have
1
2
3
4
5
6
7
8
9
10
When I click on the drop down arrow I see
4
5
6
7
8
9
10
And a blank cell, I want to see it as it is listed in the named range

 

[rs2k]

get rid of the blank, that should do it.

Colin.

 

[rs2k]

Dee,
If the blank is to add a new entry, try this for your range, then your list will pick up all entries made.

=OFFSET(YOURNAME!$A$1,0,0,COUNTA(YOURNAME!$A:$A),1)

Colin

 

[dee101]

Re: Data validation list shows what's at the bottom and not

Colin, the blank just shows up in the valadation list, it is not at the bottom of the range. I changed it to
=OFFSET(Names!$C$1,0,0,COUNTA(Names!$C:$C),1)
and the list shows from top to bottom, but it also shows whats in my header row, looks like I will have to delete it for this to work