Forum Discussion
Will the UNIQUE FILTER functions work on a dataset that was created using VSTACK?
I combined 5 tabs of data using VSTACK. I tried to use the UNIQUE FILTER functions to extract all of the names (and remove blank cells). But I keep getting an error message (i.e. a message saying t...
should work fine. maybe you could have posted the formula giving the error or better a link to your worksheet (or one that is scrubbed of any private information)
I'm relatively new and not 100% sure about posting docs. However, here's the formula, =unique(filter(VSTACK!B4:B344,VSTACK!B4:B344,<>"")). The error message only says there is a problem with the formula.
If this is not enough information for you to assist, I understand. I'll try something else.
If this is not enough information for you to assist, I understand. I'll try something else.