I am working on a dataset to track quantitative info related to contracts for a company I work for.  Each contract can have up to a dozen or so rows of data assigned to it, and we use a unique contract ID to be able to identify an individual contract.  However, occasionally we make a mistake when uploading the data, so we also assign sort of a consecutive upload ID so that we know that a contract has been uploaded more than once.  Where it gets a little tricky is that the number of rows associated with the contract might change in between uploads.  Here is an example:   Contract ID; Upload ID; Row 1, 1, 1 1, 1, 2 1, 1, 3 1, 1, 4 2, 1, 1 3, 1, 1 3, 1, 2   So here we have completed an upload of 3 contracts.  Later on characteristics of the contracts have changed, so we have to do another upload, and then maybe we need yet another revision of one particular contract so we do a 3rd upload.  Now the dataset looks like this:   Contract ID; Upload ID; Row 1, 1, 1 1, 1, 2 1, 1, 3 1, 1, 4 2, 1, 1 3, 1, 1 3, 1, 2 1, 2, 1 1, 2, 2 1, 2, 3 1, 2, 4 1, 2, 5 2, 2, 1 3, 2, 1 1, 3, 1 1, 3, 3 1, 3, 5   So the question is, is there a function that will pull me all rows related to a specific contract that are from the latest upload?  So ultimately I'd want to pull this:   Contract ID; Upload ID; Row 2, 2, 1 3, 2, 1 1, 3, 1 1, 3, 3 1, 3, 5   Many thanks in advance for your help.   ... View more