Forum Discussion
BY Column Function returning error on Query
DMills74 You realize this is a Microsoft Excel forum not a Google Sheets forum right?
I also use sheets but never used this "Query" function so looked it up to learn what it is and notice the last parameter is Number of Columns and you are passing "1". Shouldn't that be a number and not text?
Yes I do understand this, however most people who are excel knowledgable are also fairly google sheet knowledgeable except a few nuances such as this query function from time to time, but it is not too much out of their scope and I can usually trust those on this forum over many others for great answers so I tend to dig a little here first.
Not quite sure your question However. Where C=""SSF"" is specifically looking for SSF in column C and returning the info based on the select function of Columns,
The problem is the BY Column is apparently also a function of some sort where it changes the function to look for the error it shows. Where BY is a column name it apparently triggers something in this particular query function. No other Column I have found does this error