Will the UNIQUE FILTER functions work on a dataset that was created using VSTACK?

Copper Contributor

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 there's an issue with the formula). I'm not sure if the formulas won't work with this particular dataset because the list was created using the VSTACK function.  Any thoughts?

3 Replies
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.
Found the error....I had a comma out of place :(