Some context: I have a very large Google Sheet I imported from Google Forms and I want to analyze the responses I have gotten based on a specific question (the question divides the participants into two regions)
The question I want to filter by is on Row C and this is my command that I put in A2 to filter
=FILTER(A2:AB160, C2:C160=the said region)
However I am getting "Formula parse error" when I try to run it. I have tried this both with Iterative calculation on/off but I get the same results.
Another thing that might be useful is that there are some open-ended question/multiselect with the option to give an open ended answer along with selectable options. So there are some cells in the sheet that are either blank or have a multitude of different answers.
However the question I want to sort by has only two responses and I made sure to have to correct spelling and capitalization of the answer in my FILTER function, I have also tried both with and without quotation marks.
I am a highschool student who is new to this, help would be much appreciated!