LinkBack URL
About LinkBacks
When I use the first formula as data validation it works but shows only one word.
Is there a way to conver the resultant array of 2nd formula in something acceptable to use in data validation?
Thanks again for the help
When I use the first formula as data validation it works but shows only one word.
Is there a way to conver the resultant array of 2nd formula in something acceptable to use in data validation?
Thanks again for the help
No, can't be done with that formula.
The formula would have to resolve to a range of cells.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Ok, thank you for the help Tony.
Regards
You're welcome. Thanks for the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks