Is there a way to take this formula =QUERY('ABD1'!A1:Z,"Select * Where C = 'yes' and D = 'CAT'") and have it only import columns A-F and M-S? And make the last entry, first.

  • It's not clear if "and make the last entry first" means that only the last entry should me moved or if you are looking to change the order of all results. – Rubén Jun 29 '17 at 17:46

Please try:

=QUERY('ABD1'!A:S,"select A,B,C,D,E,F,M,N,O,P,Q,R,S where C = 'yes' and D = 'CAT'")

If you want the first to be last you will have to specify what to order by.

| improve this answer | |

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.