Timeline for Importrange with multiple criteria
Current License: CC BY-SA 4.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 12, 2022 at 15:19 | history | edited | serenesat | CC BY-SA 4.0 |
deleted 12 characters in body
|
| May 10, 2022 at 1:37 | comment | added | Tedinoz | you can add multiple criteria with one query. This goes without saying. The issue is "what is the syntax to reference the parameters in the OP question?" - "<=today()" and "=Partner". | |
| May 9, 2022 at 18:48 | comment | added | Stuart Bell | I tried this =QUERY(Data_save!$A$1:$G,"select * where A > date '"&TEXT(A2:A,"2022/04/01")&"' and A <= date '"&TEXT(A2:A,"2022/05/09")&"'",1) but it returns #value! error - it doesn't have the G:G = "Partner" part yet as I can't get this bit to work with query | |
| May 9, 2022 at 15:53 | comment | added | Stuart Bell | Thank you, I'm investigating the query function as you say. It is new to me so I have some reading up to do first | |
| May 9, 2022 at 13:11 | review | Low quality posts | |||
| May 10, 2022 at 23:54 | |||||
| May 9, 2022 at 12:50 | history | answered | supreeth guptha | CC BY-SA 4.0 |