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?


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.