Monday, February 20, 2017

yogi_Pull From Column A Those Records That Do Not Contain Partial String In Cells of Column B

Google Spreadsheet   Post  #2120
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Feb-20-2017
question by Andrey Bondar (serpstat):
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/WUqdROWRkFM;context-place=mydiscussions
Need help with array in Query function
Hi guys,

I don't understand and can't find how to use arrays as an argument in my function like this:
=QUERY(E19:E25;"select E where not  E contains '"&H19&"' And not E contains '"&H20&"' And not E contains '"&H21&"'")

How can I merge a lot of text to just use H19:H21 in Query function?

Thanks!