Query: Select BY

[sirdon]

Hi,

I have this formula in googlesheets:

Please Login or Register  to view this content.

But I am getting an error due to the "Select BY". Is there a way to get around this?

[sirdon]

This the error i am getting:

Unable to parse query string for Function QUERY parameter 2: PARSE_ERROR: Encountered " "by" "BY "" at line 1, column 8.

[AliGW]

Is this yet another attempt at solving this?

https://www.excelforum.com/for-other...only-once.html

Or is it something completely different? If the latter, there's not much chance of help without a workbook.

[AliGW]

OK, so having seen the latest post in the original thread, I can see that this is more of the same. Thread closed.

You can continue with all of this here (keep it all in one thread): https://www.excelforum.com/for-other...only-once.html