Data validation date list

  • Thread starter Thread starter ibo
  • Start date Start date
I

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
 
Apply Advanced Filter to column A, both "Copy to another location" and
"Unique records only" checked. Redefine RList using filtered data.
 
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
 
In that case you have to name the new list (the result of the advanced
filter) differently. How about SList--from Source List?
 
Back
Top