User Profile

SergS

Copper Contributor

Joined Jun 26, 2018

3 Posts

View All Badges

User Widgets

Recent Discussions

Re: UNIQUE Function in Data Validation
SergeiBaklan yes I did such a way with several helper sheets having TRANSPOSE(UNIQUE) and =$A$1#. It works, but bit slowly. Hoped there could be more elegant solution.
Jul 12, 2021 Place Excel
45KViews
0likes
0Comments
Re: UNIQUE Function in Data Validation
If I enter the same name just in the worksheets cell, than it spills the rows correctly. The problem appears only with Data Validation. Now I have found the same topic https://answers.microsoft.com/en-us/msoffice/forum/all/office-365-data-validation-error-when-using-unique/916b59b5-9d32-4c64-bf22-c3973481f1e2 with an explanation, that Data Validation does not work with Dynamic Arrays formulas. But I can't agree since OFFSET formula does work.
Jul 09, 2021 Place Excel
44KViews
0likes
0Comments
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?
Solved
Jul 09, 2021 Place Excel
excel
Formulas and Functions
office 365
47KViews
0likes
7Comments

Recent Blog Articles

No content to show