I've been using =Query(Importrange( functions for quite a while now and something I can't figure out is why the import is returning with two rows. Here's the formula I've been using:

=QUERY(IMPORTRANGE("1kYg-7Jqpe9RRE_rpRMUQy3wcY15RVN_Atx5aP43cLBI","Per 1!A1:Q100"),"SELECT Col2 WHERE Col2 contains '"&A9&"'")

It always returns with the header row from the import AND the data it's supposed to import. How do I get it to stop importing the header row?

| improve this question | | | | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.