How to filter data based on OR condition
Using the FILTER function, the conditions are AND conditions. I have tried Filter(data,or(condition,condition)) but I get mis-matched range lengths error. I have also tried using Filter(data,condition + condition) but this returns no results.
My apologies if the solution has already been described, I have spent some time searching but cannot locate the solution here
return all rows where values in column A are greater than 5 AND ALSO less than 10 OR the values in B are greater than 5
generates a parser error. I have tried various combination of brackets. How to achieve this?
Some community members might have badges that indicate their identity or level of participation in a community.
Member levels indicate a user's level of participation in a forum. The greater the participation, the higher the level. Everyone starts at level 1 and can rise to level 10. These activities can increase your level in a forum:
- Post an answer.
- Having your answer selected as the best answer.
- Having your post rated as helpful.
- Vote up a post.
- Correctly mark a topic or post as abuse.
Having a post marked and removed as abuse will slow a user's advance in levels.
View profile in forum?
To view this member's profile, you need to leave the current Help page.
Report abuse in forum?
This comment originated in the Google Product Forum. To report abuse, you need to leave the current Help page.
Reply in forum?
This comment originated in the Google Product Forum. To reply, you need to leave the current Help page.