How to create drop down list using function that returns dynamic array

Copper Contributor

Hi,

 

so i'm trying to create drop down list that content is from a function that return dynamic array.

fahmi13_1-1586105217769.png

like shown at the above image.

 

i know that i can do it like this

fahmi13_0-1586105154746.png

 

but this solution take more space. I want it to be as concise as the first image.

 

is there any solution for this? Thanks!

1 Reply

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. 

 

https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/40103752-data-validation-to-hold... 

 

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.