Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =FILTER(E1:H,,E1:E<>B1,E1:E<>B2,...)
- =QUERY(A2:H,"Select E, F, G,H where E !='"&B2&"'' and E is not null")
- `=QUERY(A2:H,"Select E, F, G,H where E !='"&B2:B&"'' and E is not null")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
