Forum Discussion

SergS's avatar
SergS
Copper Contributor
Jul 09, 2021

UNIQUE Function in Data Validation

I'm trying to use a Name, containing UNIQUE formula in Data Validation, but it throughs an error: The Source Currently Evaluates To an Error.  Is it a bug?    
  • SergeiBaklan's avatar
    Jul 09, 2021

    SergS 

    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#

Resources