If in a workbook I have a column of importance, in this case Animal. I have multiple Cats. I do not need all the Cat rows, I just need one with the lowest Start and the highest end. So, in this case my result would give me one row with Cat like so.
I want to do this for all of the Animals in my workbook. Thanks

I want to do this for all of the Animals in my workbook. Thanks