I am currently using the QUERY function to move relative information to another sheet, which is then used for forecasting. Now what is currently happening is the same business names are showing up in the forecasting sheet. I have a correct QUERY function, to further this I would like to then remove duplicates from that function. How do I do this?

My current formula is:

=QUERY(Business!$A$2:$H$1000,"select A,C,D,G, H order by A desc limit 1000 ")
  • can you share a copy of your sheet? – MARK MY ANSWER Jul 27 '18 at 20:15

did you try =UNIQUE ?

=UNIQUE(QUERY(Business!$A$2:$H$1000,"select A, C, D, G, H order by A desc limit 1000 "))

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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