Data Validation List Filter Function

[nburaq]

Hi,
Is there anyway to use filtered results per cell for data validation list? When I use filter function for rows in a column then it gives an Spill error and Data validation list only shows #SPILL! error in the list. I have asked the same question 2 times before but still no luck.
Thanks for your help and comments.

 

[Fluff]

Duplicate to: Drop Down List based on Cell Value

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.