excel data validation list 在 Searchable Drop Down List in Excel (Very Easy with FILTER ... 的評價 ... <看更多>
excel data validation list 在 Excel Data validation list with array formula - Stack Overflow 的評價 You are on the right way - and yes: this is annoying and definitly not intuitiv. You have to add a # after the reference to your range when ... ... <看更多>
