I just learned this new function so please bare with me.
I have created name range
=OFFSET(qryATL!$A$2,0,0,COUNT(qryATL!$A:$A),1) ( this is column with a date)
and named it "qryATL".
I tried to use the validation list so that there will be a dropdown to
choose the date.
However, i don't know if because there are 64,000 rows, there are nothing
there on my validation list.
I went Validation, from the list, source: =qryATL.

so I deleted some rows, and left 15 rows, and I see the list on the dropdown
box. Is there a limit to the drop down box?
Also, is there anyway to group the dropdown box? for example, I have
several 1-23-05, i want to have the drop down box show that once.

Thank you!