Query and ImportRange Command Help on Google Sheets

[mgoldie1]

This is probably an easy question. I'm trying to update my query:

=Query(IMPORTRANGE("url","DraftKings!A5:J5000"), "Select * Where NOT Col10 contains 'Partn'", 0)

I want to add "unless Col3 contains "NHL". In other words, If Col10 contains "Partn", it should not be imported unless Col3 contains "NHL".
Sorry if this is a simple one. Thanks.

 

[Joe4]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Query and ImportRange Command Help
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[mgoldie1]

Sorry, I didn't realize the rules about cross posting. This is where I posted it:

Query and ImportRange Command Help

This is probably an easy question. I'm trying to update my query: =Query(IMPORTRANGE("url","DraftKings!A5:J5000"), "Select * Where NOT Col10 contains 'Partn'", 0) I want to add "unless Col3 contains "NHL". In other words, If Col10 contains "Partn", it should not be imported unless Col3...

www.excelforum.com