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
Query MAX group by
google spreadsheets