I have a Google Sheet containing all responses to the questionnaire from multiple branches. It is like an audit where I have to answer OK or NOK, and if it's NOK I can indicate later that this fault has been corrected.

So the problem comes when I want to represent this data. The sheet contains ALL historic responses. It can be more than one answer for the same question. So I want to group by question per question category and per branch, in this order, and limit to show only the latest answer.


This is an example sheet of the data: in the DATA sheet there are all the responses and in the DESIRED RESULT sheet is the data I would like to obtain to show in the reports.

I tried with QUERY formula, but I am not able to group by multiple parameters, and maintain the order.

1 Answer 1


The simplest solution is:

=query(DATA!$A$1:$F;"select A,B,C, max(D), max(E), max(F) where A is not null group by A,B,C ";1)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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