Currently I am using Google Sheets but am seriously considering converting to excel for this particular workbook.
One of my concerns is finding a solution for the issue below.
I have a similar question open in the Other Apps section for Goggle Sheets specifically.
Can anyone please help with a solution for Excel 365?
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!
One of my concerns is finding a solution for the issue below.
I have a similar question open in the Other Apps section for Goggle Sheets specifically.
Can anyone please help with a solution for Excel 365?
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!
