Advertisement
Guest User

Untitled

a guest
Feb 21st, 2020
202
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.46 KB | None | 0 0
  1. =ArrayFormula(TRANSPOSE(QUERY(TRANSPOSE(IFNA(QUERY(TO_TEXT('ESPELHO: RESPOSTAS'!A:DP); "where "&TEXTJOIN(" and "; 1;
  2. IF(C17="";;"Col4 = '"&C17&"'");
  3. IF(C15="";;"Col3 = '"&C15&"'");
  4. IF(C9="";;"Col15 = '"&C9&"'");
  5. IF(C5="";;"Col1 = '"&C5&"'");
  6. IF(C13="";;"Col12 = '"&C13&"'");
  7. IF(C19="";;"Col5 = '"&C19&"'");
  8. IF(C11="";;"Col13 = '"&C11&"'");
  9. IF(C21="";;"Col19 = '"&C21&"'");
  10. IF(C7="";;"Col14 = '"&C7&"'"))&""; 1))); "where Col19 is not null"; 1)))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement