2

I have a Google Sheet that looks like this:

enter image description here

When someone selects Yes in Column A, I want to take the three lowest ordered Yes responses (order determined by Column C) and add those three answers to G4, G5, and G6 in lowest to highest order.

So, with the screenshot above, G4 would have 'Answer 1' (this is the lowest order item that was marked 'Yes' in Column A), and G5 would be 'Answer 3', and G6 would be 'Answer 4'.

I have no idea how to do this - any suggestions, and if possible, a sample sheet?

Thanks in advance!

1

1 Answer 1

1

Try this:

=QUERY(A2:D, "SELECT D WHERE A = 'Yes' ORDER BY C LIMIT 3",0)

This filters out all rows with "No" in the first column then sorts by the C column (which isn't necessary for your data, but if it's ever rearranged then it can reorder.) It then limits it to 3 rows.

1
  • 1
    Perfect, that works, thanks!
    – Jono Bacon
    Sep 20, 2022 at 1:03

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.