Maybe you have invisible characters or formulas showing blanks in the number
column
Since you want numbers you can change the COUNTA to COUNT which will ignore
text like "" or spaces etc



--


Regards,


Peo Sjoblom

"Don" wrote in message
...
All,
I am lost on this (Excel 2003) one. I have two different dynamic ranges I
use for validation. The first is a text list of various items. This seems
to
work fine, but the second, is simply a range of numeric quantities (eg:
1-100) with the ability to add more.

While first list does NOT display blanks at the bottom of the dropdown,
the
numeric one ALWAYS seems to do so and starts at the bottom.
I've read the contextures article - but do not see what I'm doing wrong
several suggestions said to delete blank cells in the range, but I have
done
this to the bottom of the sheet.

Here are the formulas I use for the dynamic ranges. I should add that both
ranges have a header in row 1.
The text based list:
=OFFSET(MasterContentsList!$A$2,0,0,COUNTA(MasterC ontentsList!$A:$A),1)

and the Numeric one:
=OFFSET(MasterContentsList!$E$2,0,0,COUNTA(MasterC ontentsList!$E:$E),1)