What is wrong with this code?
It is supposed to only gather the data in the is range for cols 1,2,3,5,11 for the name Bob that contain False. In my results I’m getting data that are TRUE. If I change 'not Col25 = ‘True’ to Col25 = ‘False’, I get no results at all.
=QUERY(IMPORTRANGE(" "Master!A:AB"),
"select Col1,Col2,Col3,Col5,Col11
where Col11 = 'Bob'
AND not Col25 = 'TRUE'")