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

4

Try using this:

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

Your Answer

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