Google Sheets
I currently have this formula that works great however, I need to add a dynamic filter to it.
=QUERY({INDIRECT(Projects!G1);INDIRECT(Projects!G2);INDIRECT(Projects!G3);INDIRECT(Projects!G4);INDIRECT(Projects!G5);INDIRECT(Projects!G6);INDIRECT(Projects!G7)}, "select * where Col1 is not null")
It works perfectly to remove blanks, but I also need it to look at a range of cells on another tab and if any values in that range are in Col18 of the results of this query, it should also filter those out.
Thank you!
I currently have this formula that works great however, I need to add a dynamic filter to it.
=QUERY({INDIRECT(Projects!G1);INDIRECT(Projects!G2);INDIRECT(Projects!G3);INDIRECT(Projects!G4);INDIRECT(Projects!G5);INDIRECT(Projects!G6);INDIRECT(Projects!G7)}, "select * where Col1 is not null")
It works perfectly to remove blanks, but I also need it to look at a range of cells on another tab and if any values in that range are in Col18 of the results of this query, it should also filter those out.
Thank you!
