Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =ArrayFormula(TRANSPOSE(QUERY(TRANSPOSE(IFNA(QUERY(TO_TEXT('ESPELHO: RESPOSTAS'!A:DP); "where "&TEXTJOIN(" and "; 1;
- IF(C17="";;"Col4 = '"&C17&"'");
- IF(C15="";;"Col3 = '"&C15&"'");
- IF(C9="";;"Col15 = '"&C9&"'");
- IF(C5="";;"Col1 = '"&C5&"'");
- IF(C13="";;"Col12 = '"&C13&"'");
- IF(C19="";;"Col5 = '"&C19&"'");
- IF(C11="";;"Col13 = '"&C11&"'");
- IF(C21="";;"Col19 = '"&C21&"'");
- IF(C7="";;"Col14 = '"&C7&"'"))&""; 1))); "where Col19 is not null"; 1)))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement