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
![CatFish.png](/board/proxy.php?image=http%3A%2F%2Fpctechtv.com%2Fextra%2Fforum%2Fmrexcel%2F180319Flatvalues%2FCatFish.png&hash=a9f505b35cb0dde6bfe4bb1ae5920173)
I want to do this for all of the Animals in my workbook. Thanks