Using Query Function
I have a table for wich I have the following data, as example:
Query code: =QUERY(Database!A:L;"SELECT A, C, L WHERE L=TRUE";1)
| ID | Tag | FCR |
|---|---|---|
| 1 | Problem 1 | TRUE |
| 1 | Problem 2 | TRUE |
| 2 | Problem 1 | TRUE |
| 2 | Problem 3 | TRUE |
| 3 | Problem 3 | TRUE |
| 3 | Problem 3 | TRUE |
The thing is I want to return the data ONLY if the column B value (Tag column) is similar to the next one.
So, in the example above it should return only the following lines:
| ID | Tag | FCR |
|---|---|---|
| 3 | Problem 3 | TRUE |
| 3 | Problem 3 | TRUE |
Can anybody help me?
Posted Jan 4, 2023, 6:14 PM UTC
22