Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =query(WATCHLIST!A1:BC;"Select " &E2& " where " &E2& " ="&(IF(F2=TRUE;E2;""))&"")
- =query(WATCHLIST!A1:BC;"Select " &E2& ","&E4&",I where " &E2& " ="&(IF(F2=TRUE;E2;""))&" or where " &E4& " ="&(IF(F4=TRUE;E4;""))&"")
- =query(WATCHLIST!A1:BC;"select A,C,I where C='"&(IF(B2=TRUE;A2;""))&"'")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement