Forum Discussion
How to create drop down list using function that returns dynamic array
Hi, so i'm trying to create drop down list that content is from a function that return dynamic array. like shown at the above image. i know that i can do it like this but thi...
Hi fahmi13,
Data Validation with dynamic arrays at the moment are unable to hold the arrays values, hence we need to use the helper column to make our solution work
You can vote here on Excel User Voice, maximum number of votes will help Microsoft Team to prioritize request.