Jul 09 2021 08:18 AM
Jul 09 2021 09:08 AM
I'm not sure, but if UNIQUE doesn't recognize the numbers then there will be an error like this,
as far as I can dare remember.
It could be that there are numbers in one column
and numbers are entered as text in the other column.
Hope this tip can help you.
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Jul 09 2021 09:41 AM
Jul 09 2021 12:00 PMSolution
That's by design. UNIQUE() function returns an array, and data validation doesn't work wit arrays. It works with references on ranges. Thus you need to land returned by UNIQUE() array into the range and use reference on this range. For example, if in A1 is =UNIQUE(something) in data validation you could use the list with reference on spill =$A$1#
Oct 03 2022 02:40 PM