Data validation date list

[ibo]

Hi all

I searched data validation old question and couldn't find my problem
solution.

I am using data validation with dynamic range name Rdate:

=OFFSET(data!$A$2;0;0;COUNTA(data!$A:$A)-1;1)

Data validation /list =Rdate on B2 column

and A column like below:

01.01.2003
01.01.2003
01.01.2003
02.01.2003 and so on.

Is it possible to show validation list on B2 no duplicate date. Like
01.01.2003 and 02.01.2003.

Thanks for advance

Jale

 

[Aladin Akyurek]

Apply Advanced Filter to column A, both "Copy to another location" and
"Unique records only" checked. Redefine RList using filtered data.

 

[ibo]

Hi Aladin
Thanks for quick response.

I have also to many defined name for my data base.When I use advance filter
to copy another location , my other calculation step is not working like as
below:

=SUMPRODUCT((Project=C6)*(Rlist>=$b$2)*(Rlist<=$d$2))

Because of new columns row quantity is less than the others .

I would appreciate if you could find another solution.

Best Wishes

 

[Aladin Akyurek]

In that case you have to name the new list (the result of the advanced
filter) differently. How about SList--from Source List?

 

[ibo]

Hi,
You are great.....How couldn't I think ?????