Data validation with unique formula

[Leticia]

I want to create a list with data validation taking unique values of the column #date of a table

 

[Fluff]

You will need to put the formula in a cell & then refer to the cell like

=A2#

 

[Leticia]

it works in a blank cell, but when I introduce =A2# in data validation, nothing happens

 

[Fluff]

You will need to change the A2# to point to the cell with the Unique formula

 

[Leticia]

So, when pointing to where the formula is as a text, it gives an error

and when pointing it to where there is the formula, nothing happens

 

[Fluff]

You need to use List rather than custom

 

[Leticia]

Great! Thank you very much!

 

[Fluff]

You're welcome & thanks for the feedback.