4

I'm trying to Query in only the most recent entries of each part number. I can usually figure this stuff out but cannot figure out why it only returns the (date) and not the (part number) and (most recent Quantity). 

=QUERY(A2:C, "Select MAX(A) group by (B)")

See example file: query Max group by

Improve this question

1 Answer 1

Reset to default
4

Try using this:

=QUERY(A2:C, "Select A, B, C ORDER BY A DESC LIMIT 1")
Improve this answer

Your Answer

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