Forum Discussion

MSTech605's avatar
MSTech605
Copper Contributor
Jun 02, 2023

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 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?

excel
Formulas and Functions
  • mtarler's avatar
    mtarler
    Silver Contributor
    Jun 02, 2023
    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)
    • MSTech605's avatar
      MSTech605
      Copper Contributor
      Jun 02, 2023
      Found the error....I had a comma out of place 😞
    • MSTech605's avatar
      MSTech605
      Copper Contributor
      Jun 02, 2023
      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.

Resources