Apr 05 2020 09:47 AM
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 this solution take more space. I want it to be as concise as the first image.
is there any solution for this? Thanks!
Apr 05 2020 06:53 PM
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.
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more.