Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
74
Views
Topic starter
Hi,
Is there a way to put Concatenate function directly in data validation (list) to avoid creating list outside validation function? When I try to put formula in K11 of attached for data validation in cell B16, it doesn't work.
Is there a workaround?
Thanks
Posted : 15/04/2023 4:00 pm
No. The data validation list source field does not accept formulas.
Posted : 15/04/2023 6:19 pm
