Selecting specific rows based on a function while keeping all associated data in row.

[ruthann23]

Hi all! Looking forward to learning from you and becoming a more proficient user of Excel. Here is my first question.

I would like to find an automated manner to select the row in the spreadsheet corresponding to the maximum "SubSegMile+ length for each "SegmentID" while keeping all the rest of the data in the selected rows. For instance, for SegmentID 20, I would like to have the entire row 22 selected including the HUC_12 and HUC_12_NAME (the subsegment miles breaks here on watershed). Please see attached spreadsheet (worksheet Maximum length) I am using the data to reconnect to features in a GIS setting, so I need to only have the Max rows with associated data. Thanks so much for any help you can provide. Ruth Ann