The cells A2, C2, and E2 contain the data that I want to create to create the custom data validation list. The cells B2 and D2 contain data that I do not want in the list (only text – "vs" – in them).
So I'm trying to use the following formula to get the custom list in G2. Whatever is typed in A2, C2, and E2 is what I want to dynamically add to my custom list in G2.
Here's what I use and it's not an error, but I can not define my list as desired:
= (TRANSPOSE (FILTER (A2: E2, A2: E2 <> "vs")))
Any help is appreciated and alternative methods are welcome if they work!