Hey, hope you're all doing well.
I wanted to compute the highest value from a group of values for each group. For example, from the data below, I would like to get the highest "Lab" value for each given specific "ID". There are 5 IDs (36, 37, 39, 65, 66) with each having one or more associated lab values. Is there a way to compute the highest value (the peak lab value) for each ID. This would generate 5 "Peak" values
This would be applied to a longer list of IDs.
Any help would be greatly appreciated.

I wanted to compute the highest value from a group of values for each group. For example, from the data below, I would like to get the highest "Lab" value for each given specific "ID". There are 5 IDs (36, 37, 39, 65, 66) with each having one or more associated lab values. Is there a way to compute the highest value (the peak lab value) for each ID. This would generate 5 "Peak" values
This would be applied to a longer list of IDs.
Any help would be greatly appreciated.
